Hi Geraldon

You can use this event that will run when you open the userform

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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Geraldon" wrote in message ...
How would i add a variable which is defined in a workbook
from to a label on a userform?