Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Valadation help
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 |
#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 |
#3
|
|||
|
|||
First put your list in a column somewhere out of the way............say
X1:X5, then Highlight the cells of interest...........then Data Validation Allow: List Source: click the window arrow then highlight your list be sure the box for In-cell dropdown is checked OK...........you can use the Input Message and/or Error Alert tabs as you wish......... Vaya con Dios, Chuck, CABGx3 "KimberlyC" wrote in message ... 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 |
Reply |
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) |