Macro - Cycle through a validated drop down list until reaching the end of the list

[The Gent]

Good afternoon,

I need the code for a macro that will select an item from a validated drop down list and then break whilst a form populated from a database is populated. This then needs top reapeat 200+ times cycling to the bottom of the list until there is no more data to pull through.

I have a data validation box in a worksheet named 'SOFP' and in cell B4, the list looks to a range of data in a sheet called "Locations" with data A2:A263

 

[John_w]

https://www.mrexcel.com/forum/excel...put-tab-grouping-post5308614.html#post5308614 shows how to loop through the items in a data validation list.