VBA Macro wait for dropdown list selection, then move to next cell.

[JohnZ1156]

I have a check register table. Some of the fields (columns) have data Validation dropdown Lists from which I choose.
I would like the automation macro to STOP at the dropdown cell with the dropdown list, allow me to dropdown and make a selection, then move to the next column and do the same with that dropdown list.

Also, if I use an Input Box, can I enter "nothing" ( a blank cell) and then have the macro move on to the next column?
Or must I enter a value of Zero?

 

[Legacy 143009]

My approach would be to prepare a userform with relevant comboboxes and texboxes. Place an OK button on the form.
I would also divide my code into two subs, before form show and after close.
Also create global variables outside the subs.

Run your first sub and show your userform at the end.
Get the input values to global variables for future use and close the form on OK button click event. Also make a call for your second sub.