Check out this link to Debra Dalgleish's web page on this subject.
http://www.contextures.com/xlDataVal01.html
Scroll down to number 2, which exactly addresses your issue here.
Then read through the rest of the pages for more insight on data validation.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kaci" wrote in message
...
Regarding the data validation, I have quite a long list for the user to
choose, is it possible that i saved the choices in the other worksheet?
I tried, but it does not allow me to do it.
Please kindly advice.
"Alan" wrote:
Have a look at Data Validation in Help,
Regards,
Alan.
"kaci" wrote in message
...
Hello all expert here...
I would like to know how to create a pull down in excel which limits
the
choice of the inputters?
In addition, is there any word count function that i can use to limit
the
word inputted in the text box?
Thanks much.