At http://www.excel-vba.com/v-forms-controls.htm

I have followed instructions... my code on the form is below but it won't
run... I've marked the error...

Can anybody give me any help with this?

thanks

Code is below--------------

Private Sub cmdBtnSubmit_Click()
shReport.Range("C4").Value = cbxCity.Value
cbxCity.Value = "Select a City"
frmCity.Hide
End Sub

Private Sub cmdCityCancel_Click()

cbxCity.Value = "Select a City"
frmCity.Hide

End Sub

Private Sub UserForm_Activate()

shParameterst.Activate '<-----Run Time Error 424 - Object Required
cbxCity.ColumnCount = 1
cbxCity.RowSource = "A1:A5"

End Sub