Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Option Button in form controls

How do i have group the option buttons so i can have two seperate entities?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 834
Default Option Button in form controls

You can either put them frames, or set the GroupName property.

--

HTH

Bob

"Pnoahjones" wrote in message
...
How do i have group the option buttons so i can have two seperate
entities?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Option Button in form controls

Hi,

By default when you put an option button on the sheet it belongs to the
'worksheet' group. Put a group box on the sheet and put options buttons in
that and they will belong to that group and act independently of the
worksheet group. You can have more than 1 group box.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Pnoahjones" wrote:

How do i have group the option buttons so i can have two seperate entities?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Option Button in form controls

Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this). Each group should have its own unique groupname.

Pnoahjones wrote:

How do i have group the option buttons so i can have two seperate entities?


--

Dave Peterson
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 in User Form levtweeney[_2_] Excel Programming 9 July 8th 09 07:18 PM
disable option button on user form JH Excel Programming 4 May 7th 09 09:07 PM
Form - Get Selected (true) value of Option Button MM User Excel Programming 17 September 8th 08 12:43 PM
option button (Form) George Excel Programming 2 March 8th 07 03:01 AM
Difficulties in VBA ( User form and option button) paradise Excel Programming 2 October 28th 03 01:11 PM


All times are GMT +1. The time now is 10:32 PM.

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

About Us

"It's about Microsoft Excel"