Label Value on a UserForm Thanks for the help(Resolved)

Skyhook · May 22nd, 2002, 09:47 AM

Is there a way to have a label on a user form to show the value of a cell?

Thanks in advance

[ This Message was edited by: Skyhook on 2002-05-22 08:49 ]

[ This Message was edited by: Skyhook on 2002-05-25 16:45 ]

lenze · May 22nd, 2002, 10:04 AM

Private Sub UserForm_Initialize()
Label1.Caption = Range("A1").Value
End Sub

Note:You can use other Events to run the code

Matt · May 22nd, 2002, 10:04 AM

If you use this code, the label (label1) will give you the value of cell "A1" when it loads.

Private Sub UserForm_Initialize()
Label1.Caption = Range("A1")
End Sub

hope this helps

Matt

Matt · May 22nd, 2002, 10:08 AM

Excuse the repetition, Ienze beat me to it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 09:47 AM	#1
Skyhook New Member Join Date: Apr 2002 Location: East Texas Posts: 38	Is there a way to have a label on a user form to show the value of a cell? Thanks in advance [ This Message was edited by: Skyhook on 2002-05-22 08:49 ] [ This Message was edited by: Skyhook on 2002-05-25 16:45 ]

May 22nd, 2002, 10:04 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Private Sub UserForm_Initialize() Label1.Caption = Range("A1").Value End Sub Note:You can use other Events to run the code

May 22nd, 2002, 10:04 AM	#3
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	If you use this code, the label (label1) will give you the value of cell "A1" when it loads. Private Sub UserForm_Initialize() Label1.Caption = Range("A1") End Sub hope this helps Matt

May 22nd, 2002, 10:08 AM	#4
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Excuse the repetition, Ienze beat me to it!