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