Hi,
I'd like to know if it's possible to know which object is triggering an event. I'm using the same sub a couple of times and I'd prefer not to have to enter the whole name as a string each time.
ex:
Thank you !!
Please Login or Register to view this content.
Last edited by domino111; 07-29-2014 at 03:45 PM.
Call Something("Button1")
Send in a string variable so you can test what it is.
Please Login or Register to view this content.
it's not quite what I'm looking for.. In fact I'm more looking for the equivalent of the "Me.Name" for a button or listbox, etc. So I wouldn't need to list all the possibilities
Hi,
maybe see Caller inner VBA help …
Me.ActiveControl !!! (thanks to ozgrid)
You should look at the Application.Caller object.
If the sub is called by a button on a sheet
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks