| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
You can enter the valid items in a list in the workbook. Then, use Data
Validation to create a dropdown list in cells A8:A500. There are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html KimberlyC wrote: Hi I need to make sure that the user only enters the following text into cells A8:A500 of a worksheet: IA IB IIA IIB IC If they enter anything other that the above into the cell, then a message will pop up explaing such.. I'm thinking the Data -- Valadation is the way to go.. but I'm not sure how to do this.. Any help is greatly appreciated.. Thanks in advnace! Kimberly -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
