Can't call a subroutine
Try at
Application.Run MyCommandButton & "_Click"
Tim
"donwb" wrote in message
...
Excel 2003
The following works within my code:-
Call CommandButton10_Click
where CB10 is one of many on a Userform
and CommandButton10_Click is a subroutine "on" the Userform.
The problem comes when I try to make the CommandButton10 part a variable.
My code will produce a value for the variable "MyCommandButton" which
might be CommandButton15 for example.
Then I try to make the call as follows:-
Call MyCommandButton(&"_Click")
a compile error "Expected Sub, Function or Property" results.
Is this just my bad syntax, or am I trying to do something which VBA
doesn't like?
donwb
|