View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Ragno Ryan Ragno is offline
external usenet poster
 
Posts: 3
Default cycle through checkboxes

Hi,

I currently have 18 checkboxes down 18 rows, each with thier own linked cell
in a seperate column (which is hidden from the user) that my macro's use to
read or change the state of any checkbox.

This linking works when i click on the checkbox (i.e. when i click on any
checkbox, to toggle it's state, the linked cell changes also), but when i use
a macro to change the state of the linked cell, the checkbox's state doesn't
change :S

Once i use my cursor to change the checkbox's state by hand twice, the
linked cell begins to change on cursor clicks again. What am i doing wrong?
if that question cannot be answered could someone tell me how to cycle
through each checkbox so that i can toggle thier states manually?

Thank you SO much (in advance),
Ryan