Hyperlink drop down list to cell in the sheet In Excel?

[bixha]

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. Can I upload attachment this form.

[/COLOR][COLOR=#333333]Private Sub ComboBox1_Change()[/COLOR]

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">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</code></pre>[COLOR=#333333]End Sub[/COLOR][COLOR=#333333]

 

[KennyGreens]

Hi there, I think it is discouraged to upload pictures, however yours did not get attached anyway.

Just so I'm clear on what you are trying to do, you have a dropdown list that has each month, and you want to hyperlink to go to a specific cell when that link within the dropdown list is clicked?

 

[bixha]

Hi there, I think it is discouraged to upload pictures, however yours did not get attached anyway.

Just so I'm clear on what you are trying to do, you have a dropdown list that has each month, and you want to hyperlink to go to a specific cell when that link within the dropdown list is clicked?

The DropDown list is created by using Developer tools so Como Box. Can I add attach this form?

 

[KennyGreens]

The DropDown list is created by using Developer tools so Como Box. Can I add attach this form?

I am unsure the rules on attaching forms, I apologize.

I understand the list is created with the developer tools, but what are you trying to accomplish after the list is created? You want to choose a month from the list and have it take you to a specific cell? Or do you want that month to be written in a certain cell, or what?

 

[bixha]

Please visit this like https://www.excelforum.com/excel-ge...hyperlinks-to-cell-in-the-sheet-in-excel.html I have publish and this forum as well.