In my spreedsheet I have a combo box as coded below. I also froze at Q2 my panes. When I select from my combo box it does go to the correct location but what I selected does not appear at the top but could be two or more rows down. I like the idea of freezing panes in what I am working on.
Private Sub cboTextFunctions_Click()
Application.Goto Range("C" & cboTextFunctions.ListIndex + 60)
cboTextFunctions.ListIndex = -1
cboTextFunctions.Text = "Choose a text function"