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

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


"Courage" wrote in message
...
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

thank you very much !