Hi guys,
Made a userform with several textboxes.
In the first textbox I want automatically to appear the data from cell A1.
What I have so far is:
Private Sub TextBox1_Enter()
TextBox1.Value = Range("Sheet1!A1")
End Sub
This works, but only when I give the enter. I want the data of cell A1 automatically to appear without click or enter or another action.
Made a userform with several textboxes.
In the first textbox I want automatically to appear the data from cell A1.
What I have so far is:
Private Sub TextBox1_Enter()
TextBox1.Value = Range("Sheet1!A1")
End Sub
This works, but only when I give the enter. I want the data of cell A1 automatically to appear without click or enter or another action.