ExcelBanter - Value in a textbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Value in a textbox (https://www.excelbanter.com/excel-programming/317495-value-textbox.html)

Alvin Hansen[_2_]

Value in a textbox

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

Alvin Hansen[_2_]

Value in a textbox

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

All times are GMT +1. The time now is 02:51 PM.