I have the following in Workbook_Open
getting a run time error "object required" dont get it. Complete workbook attachedPrivate Sub Workbook_Open() frmUserForm1.Show end sub
I have the following in Workbook_Open
getting a run time error "object required" dont get it. Complete workbook attachedPrivate Sub Workbook_Open() frmUserForm1.Show end sub
Peace of mind is found in some of the strangest places.
Check the name of the form you are calling.
Artik
cmbComboBox_Change() is misnamed
Making this one change to your code worksThis entire UserForm Code works a treatPrivate Sub ComboBox1_Change()Private Sub ComboBox1_Change() Sheet1.Range("I:I").Cells(ComboBox1.ListIndex + 2).Copy End Sub Private Sub UserForm_Initialize() UserForm1.ComboBox1.RowSource = "H2:H19" End Sub
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ