Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
Cycle through all Checkboxes on a worksheet | Excel Programming | |||
Cycle through pivotcharts | Excel Programming | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
Generalising macro 2 cycle thru checkboxes in frames/pages on User | Excel Programming |