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

Bizarre twist on misspelled/missing form error 1
How do you Highlight a file name and copy the path and name to avariable using VBA? 4
Form doesn't correctly show now with 2007 1
Automatically name a report when exporting to PDF 1
Print button on Report form 3
A2003 Form Filter cannot delete, shut off, or find problem 0
using Forms and VBA within Excel 3
Input Form Field Names in VBA 7

Top