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.