User Form error

[austenr]

I have the following in Workbook_Open


Private Sub Workbook_Open()

frmUserForm1.Show

end sub


getting a run time error "object required" dont get it. Complete workbook attached

[Artik]

Check the name of the form you are calling. :)

Artik

[austenr]

Check the name of the form you are calling. :)

Artik

Thanks fixed it. One more thing does the combo box look right to you? What ever I select it doesnt copy the cell contents.

[Fluff]

Cross posted https://www.mrexcel.com/board/threads/multiple-case-statements.1142017/

[SamT]

cmbComboBox_Change() is misnamed

Making this one change to your code works

Private Sub ComboBox1_Change()

This entire UserForm Code works a treat

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