Either you can leave a blank cell in your list,
or you can disable the error alert message.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AndyBui" wrote in message
...
Hi Excel expert,

I want to have a pull-down menu which contains all the values that I want
to
insert into a cell in the spreadsheet so I can easily select and insert
that
value into a selected cell.
Currently, I use the data validation feature of excel to create this
pull-down menu. However, it does not allow me to enter new values which
are
not on the list.

Is there anyway to create this kind of value list but not only allow the
user to select the desire value from the list but also enter a new value.

Thank you,
Andy Bui