Sorry, didn't quite finish that. What I was going to say was that you could
always use a userform with a listbox in that that has your custom values.

--

HTH

Bob Phillips

"Bob Phillips" wrote in message news:...
Susie,

You can't do that with an Input. You could always

--

HTH

Bob Phillips

"Susie_S" wrote in message
...
I want the users of a workbook to select values from a list when
prompted. I currently have an Input Box in my macro, but would like to
limit the user response to a list of possible answers. Is there a way
to use validation in the input box in the macro? Or is there another
way to do this?
Thanks!