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

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
 
R

Ron de Bruin

Use this

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

Or

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