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!