View Full Version : User Form error
austenr
08-04-2020, 08:06 AM
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
08-04-2020, 11:19 AM
Check the name of the form you are calling. :)
Artik
austenr
08-04-2020, 11:34 AM
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
08-04-2020, 12:52 PM
Cross posted https://www.mrexcel.com/board/threads/multiple-case-statements.1142017/
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.