Problem Populating labels on userform

Mkammari

Board Regular
Joined
Nov 23, 2005
Messages
65
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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,118,284
Messages
5,571,304
Members
412,380
Latest member
Angelagrace
Top