Hi,
I have create drop down list by VBA so from the list when i selection January to hyperlink (go) cell F2 where is January etc please see picture,attachment an code which I am using.
This time I have this code below but this code is so from DropDown list to go to Sheets but I am looking for from DropDown list to go to cell F2,G2 etc so when I selection January in Drop List to go to F2 or January cell.
Private Sub ComboBox1_Change()
'UpdatebyExtendoffice20180404
Sheets(Me.ComboBox1.Text).Select
End Sub
Private Sub ComboBox1_GotFocus()
Dim I As Long
Me.ComboBox1.Style = fmStyleDropDownList
If Me.ComboBox1.ListCount <> Sheets.Count Then
Me.ComboBox1.Clear
For I = 1 To ActiveWorkbook.Sheets.Count
Me.ComboBox1.AddItem Sheets(I).Name
Next
End If
Me.ComboBox1.DropDown
End Sub
Bookmarks