View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Adding checkboxes programmatically to a worksheet

Ben gave you the procedure for a check box from the forms toolbar. There is
also a control toolbox toolbar that has checkboxes. Which are you using as
the procedures are somewhat different for each.

--
Regards,
Tom Ogilvy

"Stef" wrote in message
...
Sorry, my last message just went out of my hands.

I add some checkboxes to a worksheet where the user can check/uncheck for
one of two options. I set the default value to False. Now I cannot figure

out
how to make the checkbox work since I cannot write the code Sub
Checkbox1_Click. How do I do that and how do I find and store the value

(True
or False) in either a cell or in a variable.
--
Stef