data cell automatically appear in textbox userform

flash3000

New Member
Joined
Nov 16, 2005
Messages
16
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.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,020
Messages
5,569,664
Members
412,286
Latest member
kychemist00
Top