Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option Button Pieter van der Walt New Users to Excel 2 March 27th 06 12:02 PM
Option Button Pieter van der Walt Excel Worksheet Functions 2 March 27th 06 12:02 PM
keep source formatting is not an option in paste option button Tina Excel Discussion (Misc queries) 0 February 20th 06 09:58 PM
Option Button Help justaguyfromky Excel Worksheet Functions 2 September 5th 05 10:28 PM
Option button Grant90 Excel Programming 1 July 28th 05 07:18 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"