ExcelBanter - Pull-down List

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pull-down List (https://www.excelbanter.com/excel-discussion-misc-queries/170505-pull-down-list.html)

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

"yclhk" wrote:

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 ?

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,

"Barb Reinhardt" wrote:

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

"yclhk" wrote:

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 ?