radiobuttons switch with space

[Guest]

Hi

I would like to know how I can switch between options within radiobuttons just by moving the cursor (so without havind to use the spacebar to select the option). Ho can I do that

Thx in advance

 

[Rob van Gelder]

Here's the easy way:

If you've got lots of OptionButtons (more than it's worth adding these
procedures manually) then you may want to investigate some form of event
capturing.


Private Sub OptionButton1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
OptionButton1.Value = True
End Sub

Private Sub OptionButton2_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
OptionButton2.Value = True
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel

Hi,

I would like to know how I can switch between options within radiobuttons

just by moving the cursor (so without havind to use the spacebar to select
the option). Ho can I do that ?

 

[Guest]

thank you very much !