User Form error

[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.

[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