Show Data validation List options in a msgbox
 

Is there any way to show the list options from a cell that are set
with Data validation List? I would like to show them in a msgbox. I
am looking for a VBA soloution.

Thanks,
Jay

Show Data validation List options in a msgbox
 

I think the closest you'd come would be with a UserForm, which you can put a
combo or list control onto and pick up those values.

Otherwise, you could use
InputBox() with the options written as part of the prompt and testing input
to verify they entered (typed in, not chosen from list) a valid item.


"jlclyde" wrote:

Is there any way to show the list options from a cell that are set
with Data validation List? I would like to show them in a msgbox. I
am looking for a VBA soloution.

Thanks,
Jay
.