Thread: Drop Down Box -Goto

Hi, I have a drop down box linked to cell A2 for example, when the change is made on the drop down box the linked cell returns the value 1,2or 3. I'm not sure if I require a code or an 'IF' command - but what I would like to achieve is that say when 2 is selected I want to goto sheet 3 A1, if 3 is selected then sheet 3 A2 and if 1 then nothing happens. Or can I make the function dependant on what the drop down box displays e.g Correct, Not Correct and Requires Change. (1,2 and 3 respectively)

Hope I make sense.

Many thanks
Chris

1) Right-click on the sheet tab
2) Select View Code
3) Paste in this sheet event code:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range

For Each Cell In Target
    If Cell.Address = "$A$2" Then
        Select Case Cell.Value
            Case 2
                Sheets("Sheet3").Select
                Sheets("Sheet3").Range("A1").Select
            Case 3
                Sheets("Sheet3").Select
                Sheets("Sheet3").Range("A2").Select
        End Select
    End If
Next Cell

End Sub

4) Close the editor and save your workbook as a macro-enabled workbook

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)