Yes / No Feature
I have a spreadsheet where I want to give the user the ability to pick "Yes" or "No", but not be able to enter anything else. I need to duplicate this for each row in the spreadsheet. Is there an easy way to do this without creating multiple drop down combo boxes each time a row is added? :confused: -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=393336 |
Good afternoon DCSwearingen Try using the Data Validation tool, set up the parameters, messages to give to the user etc and copy it down. Simple to use and made for situations such as this. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=393336 |
All times are GMT +1. The time now is 01:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com