Referencing a Sheet and Cell Location in Change Event of Combo Box

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

I have a combo box in Sheet1 of my workbook I would like after any ite
is changed in it to go to Cell A4 of my Rates Worksheet in the sam
workbook. Here is the code

Private Sub ComboBox1_Change()
Sheets("Rates").Select
Range("A4").Select

End Sub

It is breaking on this line here Range("A4").Select

What do I need to change so that it can go to A4 of my Rates worksheet
 
Use this

Sheets("Rates").Activate
Sheets("Rates").Range("A4").Select

Or

Application.Goto Reference:=Worksheets("Rates").Range("A4"), _
Scroll:=True
 
Back
Top