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.


cjtj4700 Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487881