View Single Post
  #1   Report Post  
KimberlyC
 
Posts: n/a
Default 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