I'm using the following VBA Code to change worksheets based on the a selection from a dropdown list that isn't a combo box:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("C6")) Is Nothing Then
Application.ScreenUpdating = False
Sheets(Range("AH6").Value).Select
Application.ScreenUpdating = True
End If
End Sub
C6 is where the dropdown is and AH6 is where the name of the appropriate worksheet name appears based on the selection in C6.
My problem is that the sheet doesn't change just by selecting the item. I have to click on a cell other than C6 and then click on C6 for the worksheet change to occur. How can I get the sheet to change just by selecting the dropdown list item and NOT having to click anywhere else.
Bookmarks