Excel formula(?) for choosing only 1 cell..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ~ Is it possible to create a formula or rule that allows only 1 cell
within a designated range to be selected? Similar to a survey where the user
can only choose 1 option.This is for an internal shipping request form and I
want requestors to be able to select only 1 service level (overnight, ground,
etc.). So if they click on one then change their mind, clicking on the
correct box "moves" the check mark.

Thx
 
Easy way would be a ListBox from the Forms menu.

select View, Toolbars, Forms and select the Listbox and draw a box.

Rightmouse and select Format Control, and select the Input range that
contains the options selectable. Then Select a control cell.

Hope this helps.
 

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

Conditional formatting in Excel 2010 2
Paste Special Values 2
how to print only rows with data without inlcuding rows with a formula 3
copy and paste the cell with formula ="1" 3
2 basic Excel questions for you pro's 7
Excel Visual Formula Help For Adding 1
Formula 5
Paste Values in linked Cells Only 4

Back
Top