Show Data validation List options in a msgbox

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
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro Excel problem link cells with Data-Validation option 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation 3
Size of drop down in validation list 2
data - validation - list question 2
Data-Validation -List - Pick from a drop down menu 4
Validation list in data entry form 4
msgbox in sheet 1

Top