Show Data validation List options in a msgbox

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

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
 
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.
 
Back
Top