Working with check boxes embedded in worksheets
 

I have a number of check boxes embedded in a worksheet which are all
assigned to the same macro.

Within the macro, how can I establish which is the active check box (ie the
check box that the user has clicked on)?

Nirmal

Working with check boxes embedded in worksheets
 

Option Explicit
sub testme()
dim CBX as checkbox
set cbx = activesheet.checkboxes(application.caller)
'do your stuff
end sub


Nirmal Singh wrote:

I have a number of check boxes embedded in a worksheet which are all
assigned to the same macro.

Within the macro, how can I establish which is the active check box (ie the
check box that the user has clicked on)?

Nirmal

--

Dave Peterson

Working with check boxes embedded in worksheets
 

Thanks, Dave.

"Dave Peterson" wrote in message
...
Option Explicit
sub testme()
dim CBX as checkbox
set cbx = activesheet.checkboxes(application.caller)
'do your stuff
end sub

Nirmal