LinkBack URL
About LinkBacks
I'm trying to get the name or control source (they are the same) of an image using the 'on click' event.
if I use ActiveControl, it returns the textbox I was last in, not the image..
I'm trying to get the name or control source (they are the same) of an image using the 'on click' event.
if I use ActiveControl, it returns the textbox I was last in, not the image..
I think this might do it for you.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
It errors out at the "Dim ActiveShape As Shape".... "User-defined type not defined"
if I comment that line out, "ButtonName = Application.caller" errros with "Method or data member not found"
the selection type of what i'm clicking on is an image.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks