Both great ideas, thanks! I'll play around with both ideas and see which one I like best. But life would be simpler if only a rectangle were a "control"!
Can someone explain why a command button object is considered a "Control" but not a rectangle object?
Thanks for the suggestion, but I was wondering if there was something equivalent to "Screen.ActiveControl"? I was hoping to make a single function that I could assign to the "On Click" event of all the rectangles so that the single function would return the name of whatever the user clicked on...
I know how to use "Screen.ActiveControl" to retrieve the name of a control that the user clicks on, but how do you retrieve the name of some other object like a rectangle? Screen.ActiveControl does not seem to work for that. I have a form with about 50 rectangles, and I want to retrieve the...