View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default Obtaining Checkbox Name

The code was intended only as a demo to show that the identity could be
captured. The Application.Caller statement returns the name of the object
that called the running procedure as a text string - i.e. Application.Caller
by itself is what you are looking for. (Run MsgBox Application.Caller).

Regards,
Greg

"RjS, CISSP" wrote:

Hmmmm - Thanks... But that gets the caption (or label) but still does not
return the name of the checkbox so I can use it to test for Checked or
UnChecked.

"Greg Wilson" wrote:

MsgBox ActiveSheet.CheckBoxes(Application.Caller).Caption

Regards,
Greg

"RjS, CISSP" wrote:

Hi - I have a form with a large number of identical checkboxes on it. All
were created from the Forms toolbox. I would like to have one macro service
all checkboxes when they are checked or unchecked, however I have been unable
to figure out how to obtain the name of the invoking checkbox.

Thanks,