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)
Bookmarks