i need to have a label containing the value the user key into the
textbox. how do i write a code for it?


thanks :)

Try something like

Private Sub TextBox1_Change()
Me.Label1.Caption = Me.TextBox1.Text
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"paradise" wrote in message
om...
i need to have a label containing the value the user key into the
textbox. how do i write a code for it?


thanks :)

try this

Private Sub TextBox1_Change()

Label1.Caption = TextBox1.Text

End Su

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com