I have found out how
Alvin


"Alvin Hansen" skrev:

Hi!!
I try to give a textbox a value from a sheet or a variabel
well i can that but not when i open my userform
i write this
Gammel.Value = Format(Sheets("gemt").Range("A1"), "0000")
how can i get this "Gammel" to take the value when i open the form

Best regards alvin