UserForm Option button select using keyboard

[jjlafond]

Hello,

I created a UserForm with 3 option buttons, and it works fine. When The UserForm is called, the box pops up, and I can click on the buttons and continue.

What I would like to do is select the option button by keyboard instead. I can tab through each option, but the tab seems to highlight the text, not the bubble, and pressing enter does not fill the bubble.

Any ideas on how to select the bubble using the keyboard?

 

[VBA Geek]

Suppose you've 3 option buttons


Alt + D will "tick" Option Button 1
Alt + S will tick option Button 2
Alt + A will tick option button 3

Private Sub UserForm_Initialize()


    Me.OptionButton1.Accelerator = "D"
    Me.OptionButton2.Accelerator = "S"
    Me.OptionButton3.Accelerator = "A"


End Sub

 

[jjlafond]

Correct me if I'm wrong, but it's possible to create subs() for clicking on the label next to the option buttons. Could I set up a Me.OptionButton1.Accelerator of some sort to tick a button when enter is pressed on each corresponding label?

I'm just trying to simplify things a bit, and remove the Alt+ step now, being picky.

 

[Norie]

Instead of Enter press Space.

 

[jjlafond]

Thank you, Space worked perfectly!

Just for the sake of learning Excel, would it still be possible to use something like Me.OptionButton1.Accelerator as a sub for the bubble label, or even just "On Enter(or any key), OptionBuutton1=TRUE" to make that work with any key?