Excel, Repost: (workaround no good) Change the state of a toggle button without running the click event

Repost: (workaround no good) Change the state of a toggle button without running the click event

Author	Message
Mark Stephen #1 / 3	Repost: (workaround no good) Change the state of a toggle button without running the click event When I click a button I want another button (a toggle) to change from deppressed to undepressed. so I just say: ToggleButton.Value = False Trouble is when it runds it goes to the click event for that button which I don't want to run, I just want to change it's state. Anyone know a workaround or how to access the state property of the button alone? Thanks for your help, kind rgds, Mark Sorry for the repost but the workaround I devised had a fatal flaw, the code in the oither two buttons never worked!!! Dohhh
Tue, 17 Aug 2004 21:09:58 GMT

Tom Ogilv #2 / 3	Repost: (workaround no good) Change the state of a toggle button without running the click event See answer to your original post. Regards, Tom Ogilvy Quote: > When I click a button I want another button (a toggle) to change from > deppressed to undepressed. so I just say: ToggleButton.Value = False > Trouble is when it runds it goes to the click event for that button which I > don't want to run, I just want to change it's state. Anyone know a > workaround or how to access the state property of the button alone? > Thanks for your help, kind rgds, Mark > Sorry for the repost but the workaround I devised had a fatal flaw, the code > in the oither two buttons never worked!!! Dohhh
Tue, 17 Aug 2004 21:38:47 GMT

:][ OZDOC 1050 ][ #3 / 3	Repost: (workaround no good) Change the state of a toggle button without running the click event Mark, all ive done here is a small macro that changes the linkedcell (this can be a hidden cell) the toggle button is assigned to, it could be built into your code. Regards Pete Sub resettoggle() Range("N1").Select ActiveCell.FormulaR1C1 = "false" End Sub Quote: > When I click a button I want another button (a toggle) to change from > deppressed to undepressed. so I just say: ToggleButton.Value = False > Trouble is when it runds it goes to the click event for that button which I > don't want to run, I just want to change it's state. Anyone know a > workaround or how to access the state property of the button alone? > Thanks for your help, kind rgds, Mark > Sorry for the repost but the workaround I devised had a fatal flaw, the code > in the oither two buttons never worked!!! Dohhh
Wed, 18 Aug 2004 02:28:50 GMT

Page 1 of 1

[ 3 post ]