getting focus on an optionbutton

[Len]

I have a userform with three text boxes and nine
optionbuttons. The optionbuttons are in one group. When I
tab through the optionbuttons I want the focus to move
from one optionbutton to another and have the optionbutton
take focus (i.e. get the dot in the button). Tabbing
causes the caption on the optionbutton to be highlighted
but the option button actually does not get focus (i.e.
OptionButton1.Value = False). I want "OptionButton1.Value
= True" to occur when I tab to the optionbutton. How do I
get this to happen? Is this possible?

 

[Harald Staff]

Hi

Private Sub OptionButton1_Enter()
OptionButton1.Value = True
End Sub

Private Sub OptionButton2_Enter()
OptionButton2.Value = True
End Sub

HTH. Best wishes Harald

 

[Tom Ogilvy]

Harald showed you how to do what you requested, but just to clarify, getting
focus doesn't involve changing the value. the control has the focus when
you tab to it.

 

[Guest]

Yes, that works!!!

Thanks Harald Staff

Len

-----Original Message-----
Hi

Private Sub OptionButton1_Enter()
OptionButton1.Value = True
End Sub

Private Sub OptionButton2_Enter()
OptionButton2.Value = True
End Sub

HTH. Best wishes Harald

"Len" <[email protected]> skrev i melding


.