Excel formula(?) for choosing only 1 cell..
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 |
Excel formula(?) for choosing only 1 cell..
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 |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com