Excel, Change the state of a toggle button without running the click event

Change the state of a toggle button without running the click event

Author	Message
Mark Stephen #1 / 5	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
Tue, 17 Aug 2004 20:44:19 GMT

Tom Ogilv #2 / 5	Change the state of a toggle button without running the click event Public bStopEvents as Boolean Private Sub togglebutton1_Click() if bStopEvents then Exit sub ' rest of your code End Sub Private Sub CommandButton1_Click() bStopEvents = True ToggleButton1.Value = False bStopEvents = False End Sub 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
Tue, 17 Aug 2004 21:08:55 GMT

Ronald Dodg #3 / 5	Change the state of a toggle button without running the click event You could set the SpecialEffect Property on the toggle button to either the value '2' or to 'fmSpecialEffectSunken', then the toggle button would appear as pressed, and again, set this same property to either as the value '1' or to 'fmSpecialEffectRaised' to have it appear as depressed. Ronald Dodge Production Statistician Master MOUS 2000 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
Tue, 17 Aug 2004 21:48:00 GMT

Mark Stephen #4 / 5	Change the state of a toggle button without running the click event Dear Tom, Works like a dream. As Always, many thanks (wish i didn't have to program only in my spare time when I'm tired!!!). Quote: > Public bStopEvents as Boolean > Private Sub togglebutton1_Click() > if bStopEvents then Exit sub > ' rest of your code > End Sub > Private Sub CommandButton1_Click() > bStopEvents = True > ToggleButton1.Value = False > bStopEvents = False > End Sub > Regards, > Tom Ogilvy > > 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
Tue, 17 Aug 2004 21:43:30 GMT

Mark Stephen #5 / 5	Change the state of a toggle button without running the click event Thanks for that Ronald. Kind regards from Singapore, Mark Quote: > You could set the SpecialEffect Property on the toggle button to either the > value '2' or to 'fmSpecialEffectSunken', then the toggle button would appear > as pressed, and again, set this same property to either as the value '1' or > to 'fmSpecialEffectRaised' to have it appear as depressed. > Ronald Dodge > Production Statistician > Master MOUS 2000 > > 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
Tue, 17 Aug 2004 22:47:14 GMT

Page 1 of 1

[ 5 post ]