Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations IFRs on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ungrouping radio buttons in Excel

Status
Not open for further replies.
mohtogh

mohtogh

Chemical
Feb 21, 2001
144
Hi there,
In a Excel spreadsheet,I have two questions,that each question need two radio buttons: yes and No
(Totally 4 radio buttons). But when I put these radio buttons, Excel supposed they are all in one group (It allow me to click on just one of them). How can I separate the two pairs of (Yes/No0radio buttons?

Thanks
 
Replies continue below

Recommended for you

Sort by date Sort by votes
Put each pair in a frame control (or any control that can act as a container eg picture box, frame, etc).
 
Upvote 0 Downvote
Open the Control Toolbox and select design mode
then click properties.
Then choose each radio button in turn and find the "GroupName" property which you should set to a different name for each group of buttons.
eg if buttons 1 & 2 are to be grouped together, give them both the GroupName property (say) "Group1", and if buttons 3 & 4 are to be grouped together, give them both the GroupName property (say) "Group2". Then exit design mode.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BhagyeshVashi
  • Locked
  • Question
Need a rename macro for excel
Replies
11
Views
910
sdz
sdz
3DDave
  • Locked
  • Question
Python now integrated into Excel - apparently
Replies
8
Views
834
IDS
IDS
Kenja824
  • Locked
  • Question
excel Formula Find help
Replies
5
Views
854
Kenja824
Kenja824
jhn1611
  • Locked
  • Question
Compass question excel 4
2 3 4
Replies
62
Views
1K
IDS
IDS
Histor
  • Locked
  • Question
Split sentence in Excel 2
Replies
10
Views
329
Histor
Histor

Part and Inventory Search

Sponsor

Back
Top Bottom