VBA Combo Box to go to shape or text box in hidden sheet

[AM94]

Hi,
I have a combo box with multiple selections, what I am trying to accomplish is I want to send the user to a shape or a text box in a hidden sheet based on the combo box selection, rather than sending the user to a specified cell range in case the user decides to add/delete rows, it will mess it up.

here is my approach:

Private Sub ComboBox1_Change()

If ComboBox1 = "Hello" Then
        ThisWorkbook.Sheets("Sheet1").Visible = True
        Application.Goto ActiveSheet.TextBox("TextBox 17").Select
        ActiveWindow.Zoom = True
      
    End If
End sub

Could some please help point me in the right direction?
I am flexible to use either a text box or a shape.

Thanks!

 

[marce]

You mean this?

Private Sub ComboBox1_Change()
If ComboBox1 = "Hello" Then
        ThisWorkbook.Sheets("Sheet1").Visible = True
        ThisWorkbook.Sheets("Sheet1").Shapes("MyShape").Select
        ActiveWindow.Zoom = True
      End If
     
End Sub