choice selection button in a cell

  • Thread starter Thread starter jkkumar
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit choices in one cell dependent based on choice in other cell 1
Restrict Choice in Shared WB (drop down alternative)? 0
Possible to select a string in a locked cell? 1
Turning on data validation in one cell based on the contents ofanother cell 1
radio buttons in XL2003 2
Variable data validation 6
I copied Visible Cells Only, but it pastes only the first cell 1
Variable option list 3

Back
Top