Automatically Select a Cell

Is there a way to move the cursor to a different cell automatically depending what is typed into another cell?

Thank you

Hi Carim

My appologies that I did not give more information. I have a dropdown box located on a sheet that users can select the years 2004, 2005, 2006, 2007 etc.

When a year has been selected, I want the cell that relates to that year to be selected, ie, if they choose 2006, I want to move the cursor to cell A79, if they choose 2007, I want to move the cursor to cell A138

Thank you

Hi Carim

Thank you for your help. As I am not an expert when it comes to VBA, where do I add the code, and how do I make it relate to the year that is entered into cell E17?

Sorry for being a pain!

Hi Carim


Please ignore my last post, I have figured it out how to use it.

thank you again for your help.