Pull-down List

  • Thread starter Thread starter yclhk
  • Start date Start date
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 ?
 
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
 
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

How to create a pull down lists? 1
Populating data from a pull down 1
Can the dwnarrow box for a pull-down list be on the left? 1
single-cell multiple entry with pull-down list? 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Variable Validation List 2
Data Validation to exclude blank cells 6
Excel 2007 Pull Down List 5

Back
Top