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
Bookmarks