Pull-down List

Y

yclhk

I create a pull-down list in a cell by using Data ->Validation -> and input
the listing in the source box. How can I set the pull-down list return to
the first data after each selection ?
 
B

Barb Reinhardt

It sounds like you'd need a Worksheet_Change event to do this. What are you
doing with the entry that you make ... and then subsequently change?

Barb Reinhardt
 
Y

yclhk

Would you mean it need to creat in VBA module ? I only want to create the
pull down list simply in a cell by using menu Data ->Validation -> and input
the listing.

Thanks,
 

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

Populating data from a pull down 1
How to create a pull down lists? 1
single-cell multiple entry with pull-down list? 3
Can the dwnarrow box for a pull-down list be on the left? 1
Excel 2007 Pull Down List 5
Check for duplicate entries in pull-down list 1
=IF function, reference problem to "text strings" in Data Validati 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top