choice selection button in a cell

J

jkkumar

Hi,

I need to have a choice/radio button in a cell, wherein the user can
just choose only one option instead of choosing from the drop down menu
that appears against a cell when data validation method is used.

Ex : User has to choose one of the 3 options shown in a cell.

Can someone in this forum share the knowledge of how to go about
achieving the same ?

my skills are very limited and have only used the existing functions in
xls.
 
D

Dave Peterson

I'd show the Forms toolbar.
Then put a frame around that cell
Add 3 option buttons completely within that frame
Assign a linked cell to one of the option buttons to be able to determine which
choice was made.
 
Top