ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Radio Buttons (https://www.excelbanter.com/excel-worksheet-functions/8061-radio-buttons.html)

nir020

Radio Buttons
 
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

Michael Malinsky

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





All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com