When do you want it to happen

Say when the form is first shown
In the userform module:

Private Sub Userform_Initialize()
me.Label1.Caption = Worksheets("Sheet2").Range("B9").Text
End Sub


If you wanted to link it to a cell then use a textbox. for Properties,
change the specialeffect property to flat and the backcolor to menu bar
and Locked to true

This will make it look pretty much like a label.

--
regards,
Tom Ogilvy


"Elsa" wrote:

How do I draw information from a cell within Excel and add it to a
label/caption on a Userform?