Radio Buttons

[nir020]

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.