Can you use the name of a sub routine within itself in vba

M

Mark

I have 60 command buttons on a touch screen form. Is there a way to refer
to the name of the sub routine. E.g. I have a command button - cmd1, with
the code behind the form cmd1_click - AddItem Me.cmd1.Caption. Is it
possible to have something along the lines of Left(SUBNAME,4).Caption?

Thanks
 
M

ManningFan

Well, the subname is actually the name of the control, isn't it? So
you could pass the name of the control to a variable and possibly use
something like:
"" & ControlName & "".Caption

I've never tried it so I don't know if that's a valid reference or not.
 
A

Allen Browne

Unfortunately, VBA does not expose the name of the procedure that is
exectuing.

Unless it was called programmatically, you may be able to derive if from:
Form.ActiveControl.Name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use a variable contain the name of a sub or function to call it? 4
Bizarre twist on misspelled/missing form error 1
Calling a VBA sub routine 5
Need help in printing vba code 0
Can I get form name / routine name from Access? 5
Image Control in Sub-Routine Error 2
Interacting with label control of checkbox's 3
A2000 form ceases working under A2002 1

Top