Validation - Force entry from drop down list
I'm trying to force the data entry from the drop down list. I thought if I
set the Error Alert to "Stop" it would prevent any entry other than that from the drop down list, but I can still enter data not on the drop down list. How can I the cell to only accept data from the drop down list? |
Validation - Force entry from drop down list
Hi,
Look into Debra web http://www.contextures.com/xlDataVal02.html "JeffH" wrote: I'm trying to force the data entry from the drop down list. I thought if I set the Error Alert to "Stop" it would prevent any entry other than that from the drop down list, but I can still enter data not on the drop down list. How can I the cell to only accept data from the drop down list? |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com