View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
borg borg is offline
external usenet poster
 
Posts: 23
Default name of checkbox that was clicked in a userform

Hi,

I have a userform with a bunch of checkboxes. I would like to identify the
name of the checkbox that was clicked. Is there an equivalent statement to
the one that allows me to get the name of the shape that was clicked?

I think this works for the shapes:
msgbox activesheet.shapes(application.caller).name

I've tried:
msgbox userform1.controls(application.caller).name


Thanks you.