Cell reference to userform
 

--
I am just a beginner in vba programming for excel.

I need to show the number of a specific cell in the textlabel on my form.
How do i get the number to be shown?

Thanks

Cell reference to userform
 

Use this event in the Userform module

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

It runs when you open the userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jens Peter Nielsen" wrote in message ...

--
I am just a beginner in vba programming for excel.

I need to show the number of a specific cell in the textlabel on my form.
How do i get the number to be shown?

Thanks