User Form error

I have the following in Workbook_Open

Code:

---

Private Sub Workbook_Open()

frmUserForm1.Show

end sub

---

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

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

Artik

Quote:

---

Originally Posted by Artik

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.

Cross posted https://www.mrexcel.com/board/thread...ments.1142017/

cmbComboBox_Change() is misnamed

Making this one change to your code works

Code:

---

Private Sub ComboBox1_Change()

---

This entire UserForm Code works a treat

Code:

---

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

---