Userform Textbox vs Label

[Hjemmet]

I got this code

Private Sub Label1_Click()
Label1.Caption = Worksheets("Ark1").Range("B1")


End Sub


Private Sub Label2_Click()
Label2.Caption = Worksheets("Ark1").Range("B2")


End Sub


Private Sub TextBox1_Change()
Worksheets("Ark1").Range("B1").Value = TextBox1.Value


End Sub


Private Sub TextBox2_Change()
Worksheets("Ark1").Range("B2") = TextBox2.Value


End Sub

On my userform BUt they are NOT showing anything before i click on Both Label and Textbox
i want it to show right away when Userform Start up

and by the way How will i Get Commandbutton to close userform

i have Try this function " Hide Me" - "Unload Me" Userform Hide" and none of them Work

 

[My Aswer Is This]

You need this script in your Userform to update the label names when Userform is opened.
Now how do you expect the two textboxes to update a sheet when the Userform is Opened?
The Two textbox's will be empty when you open the Userform.

And this button you have to close the Userform. Is this button on the Userform?

If it's on the Userform.

Unload Me should work.

Do not put quotes around Unload Me

Private Sub UserForm_Initialize()
'Modified  10/2/2018  9:31:19 PM  EDT
Label1.Caption = Worksheets("Ark1").Range("B1").Value
Label2.Caption = Worksheets("Ark1").Range("B2").Value
End Sub