Yes.

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

That'll show how to setup the list for selecting items. To be able to
*enter* items not on the list, after you have the basic list set select the
Error Alert tab and uncheck: Show error alert after invalid data is entered.
Then OK.

--
Biff
Microsoft Excel MVP


"Big Rob" wrote in message
...
Can I have a drop down list that, I can either choose from or input
something
different?