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

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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.
 
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
I have a question about using UNDERLINE on a form 4
Access Manage Attachments linked to a SubForm 0
Calling a VBA sub routine 5
Access Sub form opens before the main form in MS Access 0
Getting a caption without naming the control 1
Need help in printing vba code 0

Back
Top