Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have creted a form in Microsoft Excel. It is similar to a web page in that
it prompts the user with questions from which they have to select a pre-defined answer using a drop down menu. Is it possible in Excel to replace these drop-down menus with Radio buttons so that the users can see the answers before they click on the drop down menu. Cheers |
#2
![]() |
|||
|
|||
![]()
Use the Control Toolbox to place option buttons on the worksheet. Unless
you specify otherwise, Excel will consider all options to be in the same group and therefore will allow only one to be selected. Right-clicking on an option button in design mode and selecting Properties will allow you to change the group name so that you can have several groups of options on the sheet that are independent of each other. "nir020" wrote in message ... I have creted a form in Microsoft Excel. It is similar to a web page in that it prompts the user with questions from which they have to select a pre-defined answer using a drop down menu. Is it possible in Excel to replace these drop-down menus with Radio buttons so that the users can see the answers before they click on the drop down menu. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spreadsheet "buttons" that cannot be removed | Excel Discussion (Misc queries) | |||
Can't remove Radio Button | Excel Discussion (Misc queries) | |||
What happened to Subscript and Superscript Buttons in Excel? | Charts and Charting in Excel | |||
Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |