Worksheet_Selection Change to Activate another sheet in the same workbook

Chrisowen · Sep 21st 2016

Working with data on Sheet1, I want to click on any row in Column A to activate Sheet2 or Sheet3 in the same workbook based on the value of column E. It the Value of Column E is greater than zero I want to activate Sheet2. If the value in column E is zero, then I want to activate Sheet3.

John_w · Sep 21st 2016

Re: Worksheet_Selection Change to Activate another sheet in the same workbook

In the "Sheet1" worksheet module:

Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Count = 1 Then
If Cells(Target.Row, "E").Value > 0 Then
Worksheets("Sheet2").Activate
ElseIf Cells(Target.Row, "E").Value = 0 Then
Worksheets("Sheet3").Activate
End If
End If
End Sub

Display More

Chrisowen · Sep 21st 2016

Re: Worksheet_Selection Change to Activate another sheet in the same workbook

Thank you. This works perfect!

Share