Go to a specific cell when selecting an entry in a validation list
 

I have a validation list in merged cells B4:E4 and would like a macro that
would take the user to specific cells when selecting each item of the
validation list. For example, if the user chooses "Sales", the cursor is
moved to cell A50, and if he chooses "Expenses", the cursor moves to cell C50.

Chris

Go to a specific cell when selecting an entry in a validation list
 

Make the row and column correspond to where your validation cell is located.

Add code to VBA sheet page (not module). go to tab on bottom of worksheet
and right click (usuallly sheet1). then select view code. paste subroutine
into pagge and make changes as needed.

Sub worksheet_change(ByVal Target As Range)

If (Target.Row = 3) And (Target.Column = 7) Then

'inset your code here.

End If

End Sub


"Christine" wrote:

I have a validation list in merged cells B4:E4 and would like a macro that
would take the user to specific cells when selecting each item of the
validation list. For example, if the user chooses "Sales", the cursor is
moved to cell A50, and if he chooses "Expenses", the cursor moves to cell C50.

Chris