Move to cell after selection from drop-down list

[Ray316]

Hi,
In excel 2003, after selecting an item from a drop-down list (D4), is it possible to move to that selection witch is found on the same worksheet in colon A. I made a template for better understanding. (Plz don't take in consideration the words. They are used only for demonstration purposes)

There is a dependent drop-down list D2 & D4.
Thank you in advance.

[Leith Ross]

Hello Ray316,

Welcome to the Forum!

This macro will Select the cell in column "A" if it is found.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

[Ray316]

Hi Leith Ross,
Thank you very much for the help. it works perfect. You are the best.