JJ,

Take a look at Inputbox in the VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JJ" wrote in message
...
Is there a way to have a message box come up that allows the user to input
a
value directly into the message box, which stores that value in a seperate
cell. I have a drop down box, and when the user picks "Other", I want them
to
be able to input their own value, except, I don't want it to remain in the
drop down box.