A user will be reviewing a user form where the information is orginally stored on a worksheet titled (Cust Inventory). I have chosen label to populate the userform with information already updated on a worksheet, however I am getting an error message "run time error 424: Object required". COuld someone please look at the following code and let me know what I am doing wrong.
Code:
Private Sub UserForm_initialize()
lblitem31.Caption = Sheets("cust Inventory").Range("A34").Text
lblitem32.Caption = Sheets("cust Inventory").Range("A35").Text
lblitem33.Caption = Sheets("cust Inventory").Range("A36").Text
lblitem34.Caption = Sheets("cust Inventory").Range("A37").Text
