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!

Worksheet_Selection Change to Activate another sheet in the same workbook

Participate now!

Share