data cell automatically appear in textbox userform

[flash3000]

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.

 

[BrianB]

Use the Initialize event of the form with the same code.