Option button enabled when tabbed to - how?
In a user form I have several Option Buttons and users can tab down them.
What I would like to do,but can't find way, is for each button's Enabled property to change to True when tabbed to. It's not life threatening but it is infuriating! Any help would be appreciated |
Option button enabled when tabbed to - how?
I don't understand.
If the .enabled property is set to false, then I can't even tab to them. On 09/15/2010 08:59, Philip wrote: In a user form I have several Option Buttons and users can tab down them. What I would like to do,but can't find way, is for each button's Enabled property to change to True when tabbed to. It's not life threatening but it is infuriating! Any help would be appreciated -- Dave Peterson |
Option button enabled when tabbed to - how?
My apologies for misleading everyone
I believe it's the Value property that when set to True the button is selected and if False, then it's not So it would be the value property I would like to change when the button is tabbed to Philip "Dave Peterson" wrote in message ... I don't understand. If the .enabled property is set to false, then I can't even tab to them. On 09/15/2010 08:59, Philip wrote: In a user form I have several Option Buttons and users can tab down them. What I would like to do,but can't find way, is for each button's Enabled property to change to True when tabbed to. It's not life threatening but it is infuriating! Any help would be appreciated -- Dave Peterson |
Option button enabled when tabbed to - how?
I don't understand why you'd want to do this.
If you're using optionbuttons, then I would guess that you have multiple options that are "grouped". So tabbing to one of the group would make that optionbutton's value true -- and turn off the one that was previously chosen. Personally, I just tab to the optionbutton I want to change and hit the spacebar. I wouldn't do this, but you could tie into the _enter event and do what you want. I created a userform with 5 optionbuttons and this was the code behind the userform: Option Explicit Private Sub OptionButton1_Enter() Me.OptionButton1.Value = True End Sub Private Sub OptionButton2_Enter() Me.OptionButton2.Value = True End Sub Private Sub OptionButton3_Enter() Me.OptionButton3.Value = True End Sub Private Sub OptionButton4_Enter() Me.OptionButton4.Value = True End Sub Private Sub OptionButton5_Enter() Me.OptionButton5.Value = True End Sub On 09/15/2010 10:48, Philip wrote: My apologies for misleading everyone I believe it's the Value property that when set to True the button is selected and if False, then it's not So it would be the value property I would like to change when the button is tabbed to Philip "Dave Peterson" wrote in message ... I don't understand. If the .enabled property is set to false, then I can't even tab to them. On 09/15/2010 08:59, Philip wrote: In a user form I have several Option Buttons and users can tab down them. What I would like to do,but can't find way, is for each button's Enabled property to change to True when tabbed to. It's not life threatening but it is infuriating! Any help would be appreciated -- Dave Peterson -- Dave Peterson |
Option button enabled when tabbed to - how?
Thanks for that Dave
I see what you are getting at. I think I will use your space bar tip Thanks "Dave Peterson" wrote in message ... I don't understand why you'd want to do this. If you're using optionbuttons, then I would guess that you have multiple options that are "grouped". So tabbing to one of the group would make that optionbutton's value true -- and turn off the one that was previously chosen. Personally, I just tab to the optionbutton I want to change and hit the spacebar. I wouldn't do this, but you could tie into the _enter event and do what you want. I created a userform with 5 optionbuttons and this was the code behind the userform: Option Explicit Private Sub OptionButton1_Enter() Me.OptionButton1.Value = True End Sub Private Sub OptionButton2_Enter() Me.OptionButton2.Value = True End Sub Private Sub OptionButton3_Enter() Me.OptionButton3.Value = True End Sub Private Sub OptionButton4_Enter() Me.OptionButton4.Value = True End Sub Private Sub OptionButton5_Enter() Me.OptionButton5.Value = True End Sub On 09/15/2010 10:48, Philip wrote: My apologies for misleading everyone I believe it's the Value property that when set to True the button is selected and if False, then it's not So it would be the value property I would like to change when the button is tabbed to Philip "Dave Peterson" wrote in message ... I don't understand. If the .enabled property is set to false, then I can't even tab to them. On 09/15/2010 08:59, Philip wrote: In a user form I have several Option Buttons and users can tab down them. What I would like to do,but can't find way, is for each button's Enabled property to change to True when tabbed to. It's not life threatening but it is infuriating! Any help would be appreciated -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com