retrieve name of object user clicks on

Ruggles

Guest

Posts: n/a

21st Mar 2012

I know how to use Screen.ActiveControl, but that doesn't seem to work
with the Rectangle object on a form. I want to be able to have say 50
rectangles on a form, and then retrieve the name of whichever one the
user clicks on. If there were 50 text boxes this would be easy:
Msgbox Screen.ActiveControl.name. But that doesn't work for the
Rectangle object. Is this possible?

« Execute code from string | Need help with Form objects »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
confirmation window once user clicks submit on user from	sam	Microsoft Excel Programming	4	7th Jul 2009 06:02 PM
Making A Call To The API When A User Hits A Button To Retrieve TheCurrent System User Name	R Tanner	Microsoft Access Forms	1	9th Jan 2009 08:58 PM
how do I reveerse name order last name, first name to first name, last name	Don Smith	Microsoft Excel Discussion	9	29th Nov 2006 10:55 PM
Single clicks detected as double clicks	=?Utf-8?B?Umlzc2EgQW5u?=	Windows XP Help	4	27th May 2005 10:01 PM
Show user defined commandbarButton when the user right clicks on Contact	Venugopal	Microsoft Outlook Program Addins	3	19th Nov 2003 01:49 PM