I currently have 4 worksheets for the summary of my data. In each of them I have a combox that has a list of each worksheet. When I select a certain worksheet I want it to go to that worksheet. Here is what I have for code but I can't get it to work. Any help would be greatly appreciatied.



For the Macro I have:

Public Sub Select_Brand()

If Brand = "BV" Then
Sheets("BV").Select
ElseIf Brand = "FAX" Then
Sheets("FAX").Select
ElseIf Brand = "FWD" Then
Sheets("FWD").Select
ElseIf Brand = "PA" Then
Sheets("PA").Select
End If

End Sub



For the ComboBox on each worksheet I have this code:

Private Sub ComboBox1_Click()
Brand = ComboBox1.Value
Call Select_Brand
ComboBox1.Value = ""
End Sub

Thanks

Marc