Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to create yes/ no box for selection?

Does anyone have any suggestions on how to create a selection box for yes and
no within Excel? which can only be selected one option at a time.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How to create yes/ no box for selection?

hi
options buttons were designed for this.
the options button has a group name property that you can set to control how
the option button work as a group. when you first create the button, the
group property is set to the sheet name but you can change it.
example. the first 2 options button(yes/no) could be set to group1
the next 2 options buttons(yes/no) could be set to group2 and so on.
the above is option buttons from the control tool box(activeX). the forms
options button gave a group name property but you can only set it if it is on
a form. so be carefull there.

regards
FSt1

"Eric" wrote:

Does anyone have any suggestions on how to create a selection box for yes and
no within Excel? which can only be selected one option at a time.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to create yes/ no box for selection?

Thank you very much for your suggestions

From Form Control Panel, I can create a group area and insert 2 checkboxs
within it, one is Yes and the other is No. Could you please give me any
suggestions on what to do in the next step?

Do you have any suggestions?
Thank you very much for any suggestions
Eric

"FSt1" wrote:

hi
options buttons were designed for this.
the options button has a group name property that you can set to control how
the option button work as a group. when you first create the button, the
group property is set to the sheet name but you can change it.
example. the first 2 options button(yes/no) could be set to group1
the next 2 options buttons(yes/no) could be set to group2 and so on.
the above is option buttons from the control tool box(activeX). the forms
options button gave a group name property but you can only set it if it is on
a form. so be carefull there.

regards
FSt1

"Eric" wrote:

Does anyone have any suggestions on how to create a selection box for yes and
no within Excel? which can only be selected one option at a time.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to create yes/ no box for selection?

Check your other post, too.

Eric wrote:

Does anyone have any suggestions on how to create a selection box for yes and
no within Excel? which can only be selected one option at a time.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric


--

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
Copy Selection - Transpose Selection - Delete Selection Uninvisible Excel Discussion (Misc queries) 2 October 23rd 07 04:18 PM
Possible to create multiple-selection drop-down box in Excel? Jenty56 Excel Worksheet Functions 1 March 31st 07 06:57 AM
How to create a pull down menu for selection? Eric Excel Worksheet Functions 2 March 10th 06 04:51 PM
why does sorting large columns create errors in top selection? Mitch Excel Worksheet Functions 1 November 17th 05 09:19 PM
How do you create a selection box for data entry within excel Ligia Magnus Excel Discussion (Misc queries) 1 May 25th 05 08:10 PM


All times are GMT +1. The time now is 11:59 PM.

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"