Gustav Brock
gustav at cactus.dk
Fri Nov 14 02:15:09 CST 2003
Hi Darren At least you can retrieve the name of the module ...: <code> Public Sub ModuleName() Dim strModuleName As String On Error Resume Next strModuleName = Null strModuleName = Err.Source MsgBox strModuleName End Sub </code> /gustav > Is there a way to determine the current sub name once you are in it then display it > Is there a Current Sub Property? etc > eg (PSEUDO Code) > Private Sub MySub() > Msgbox "My Sub Name is " & Application.SubName > End sub > Many thanks in advance > Darren