LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? Charles A. Wilson Charts and Charting in Excel 1 December 17th 09 03:03 AM
Cycle through all Checkboxes on a worksheet the00snoopy Excel Programming 1 July 31st 07 11:22 PM
Cycle through pivotcharts Michael[_44_] Excel Programming 1 April 10th 07 05:44 PM
How do I keep result from 1 iteration cycle to use in next cycle? sgl8akm Excel Discussion (Misc queries) 0 July 27th 06 08:28 PM
Generalising macro 2 cycle thru checkboxes in frames/pages on User LFNFan Excel Programming 0 March 7th 05 03:43 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"