This worked for me!
Thank you vb5prgrmr very much for your suggestion!
The code that i got to work is listed below.
For others who may want to do this, here are some points to be aware of:
1 I did quite a bit of searching before posting my own question. Other people seemed to be satisfied when they were pointed to Eval or Application.Run . I do not know why these worked for others and not for me. Therefore,...
User Profile
Collapse
-
Reg9 started a topic how can i call a private sub using a variable that contains the name of the sub?in Visual Basichow can i call a private sub using a variable that contains the name of the sub?
Private Sub cmdProcessEvent s_Click()
strEventID = "Audit0001"
'This works:
Audit0001
'These do not:
Eval (strEventID)
Application.Run strEventID
End Sub
Private Sub Audit0001()
MsgBox "Here i am"
End Sub
No activity results to display
Show More
Leave a comment: