View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Checkbox behaving strangely

Do you have the code behind the correct sheet?

click on the design mode button on that control toolbox toolbar.

Doubleclick on checkbox61. You'll see where the code belongs.

(Don't forget to exit design mode when you're done.)

It did work for me (although, I changed the number of checkboxes (too lazy to
make 61!)).

If it doesn't work, try creating new worksheet in a new workbook. Add a few
checkboxes from the controltoolbox and add the code to the first checkbox. (and
change that loop to " for i = 2 to 5" (or how many you added)).

Shilps wrote:

I'm Dave but now nothing is happening. Now when I click on Checkbox61, not even a single Checkbox from index 41 to 60 is getting selected. Yes these are the Checkboxes added to the worksheet from the control toolbox


--

Dave Peterson