Option Button

[ceemo]

I have created a range of option buttons on my user form and have grouped them in thecode as advised in the help files on VB. This works fine however when i click between the option buttons the activie one deactivates and i then have to click again to get the new selection to hghlight.

Id rather it switched with one click rather than two, can this be done?and what am i doing wrong?

[Chip Pearson]

The normal mode of operation of option buttons is the way you
want it to work. I can't think of a reason they would behave the
way you describe. Do you have any code behind the option buttons?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ceemo" <[email protected]>
wrote in message
news:[email protected]...
>
> I have created a range of option buttons on my user form and
> have
> grouped them in thecode as advised in the help files on VB.
> This works
> fine however when i click between the option buttons the
> activie one
> deactivates and i then have to click again to get the new
> selection to
> hghlight.
>
> Id rather it switched with one click rather than two, can this
> be
> done?and what am i doing wrong?
>
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile:
> http://www.excelforum.com/member.php...o&userid=10650
> View this thread:
> http://www.excelforum.com/showthread...hreadid=397668
>

[ceemo]

hi here's the code im using to link the option buttons

OptionButton5.GroupName = "Weeks"
OptionButton6.GroupName = "Weeks"
OptionButton7.GroupName = "Weeks"
OptionButton8.GroupName = "Weeks"
OptionButton9.GroupName = "Weeks"