Move to cell after selection from drop-down list

**Ray316** · 05-23-2011, 12:35 PM

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** · 05-23-2011, 01:03 PM

Hello Ray316,

Welcome to the Forum!

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

Private Sub Worksheet_Change(ByVal Target As Range)

  If Not Intersect(Target, Range("D2,D4")) Is Nothing Then
     Set Cell = Columns("A:A").Find(Target, , xlFormulas, xlWhole, xlByRows, xlNext, False)
     If Not Cell Is Nothing Then Cell.Select
  End If
  
End Sub

How to Save a Worksheet Event Macro

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