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