Autocycle through drop down list on 'Save'

[PingTing]

i have a worksheet that takes some user input and saves it to a table. The user has to do this for multiple properties. Right now, in cell F7, the user has to select each property from the drop down menu. What i'd like to do is each time the user hits 'Save' it automatically skips to the next property in the list (the drop down list is simply a Data Validation list linked to the first column in Table1 on the Properties tab). I want to though keep the drop down aspect, so that if the user doesn't need to enter data for a specific property, they can use the drop down menu to go to the next property and then carry on.

see attachment...

For reference - the 'Save' button just copies the data to the Database tab and clears some parts of the form.

[Kaper]

May be such modification to your code (of course cell variable declaration could be moved to other declarations near the start of the sub):

Please Login or Register  to view this content.

[PingTing]

Brilliant, Kaper. Just brilliant. Thank you so much. That is a perfect solution.

[Kaper]

Glad it worked for you. And thanks for marking thread SOLVED and for reputation point