ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Option Button (https://www.excelbanter.com/excel-programming/337898-option-button.html)

ceemo[_17_]

Option Button
 

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

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

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=39766


Chip Pearson

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

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[_22_]

Option Button
 

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

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=39766



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com