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

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

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