View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to create a group combo box (Yes/No)?

User should make his own selection on Yes/No, but when I create the radio
buttons within a group, one of the button must be selected, which will cause
some confusion for user, so I would like an option to unselected all buttons,
so user know that he needs to select Yes/No.
Do you have any suggestions for my case?
Thank you very much for any suggestions
Eric

"Dave Peterson" wrote:

I don't understand.

Why would you only want to select the true or false just during testing? If you
don't want to give people a choice, then don't.

Eric wrote:

When I insert a group table and 2 checkboxs into it, could you please tell me
what to do next in order to able select Yes / No only on testing?
Thank everyone very much for any suggestions
Eric

"Dave Peterson" wrote:

How about an alternative?

Instead of a combobox, use a couple of optionbuttons from the Forms toolbar.

If you have to add more than 2 optionbuttons to that worksheet, you have to put
each pair of optionbuttons it their own GroupBox (also on the Forms toolbar).

In xl2003 menus, you can show the Forms toolbar:
View|Toolbars|check Forms



Eric wrote:

Does anyone have any suggestions on how to create a group combo box (Yes/No)?
which will allow to select one option only?

Does anyone have any suggestions on how to do it?

Thanks in advance for any suggestions

Eric

--

Dave Peterson


--

Dave Peterson