Automatically move to next available cell after drop-down menu input

[CV899000]

Hi,

I have a sheet where I have several drop-down menus.

I would like to know if I can get a VBA code that shifts the active cell as soon as a value have been chosen in a drop-down menu.

Example:

Lets say that cell A1 has a drop-down menu containing "YES" and "NO".
Depending on my choice, the next available cell (the other cells will be locked) will be either B2 if "YES" or B3 if "NO"

and so on with my other drop downs also.


But how do I make excel change to the next cell automatically when I choose one of the answers so that I do not have to move my cursor or press enter to move to next cell.

 

[CV899000]

Thank you, that was what I needed!

I actually tried explaining that in the beginning of this post.
I wrote that I would like to have the cursor move with every change in the cells. I wrote that to avoid having to write every single possible outcome of the drop-down menu.

 

[Joe4]

Great, glad we got it working.