change a label to match format.

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Erdinç E. Karaçam

Board Regular
Joined
Sep 23, 2006
Messages
202
Hi,

You can try these sample.

Label1 in UserForm1, and TextBox1 in UserForm2.


Code:
Private Sub UserForm_Initialize()
    Me.Label1.Caption = UserForm2.TextBox1.Text
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,113,847
Messages
5,544,637
Members
410,627
Latest member
georgealice
Top