View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
anilsolipuram[_26_] anilsolipuram[_26_] is offline
external usenet poster
 
Posts: 1
Default TextBox Format/Editing Problem


This code will be invoked when ever cursor from textbox1 is moved to
another control.


Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Text = Format(TextBox1.Text, "#,##,000.00")
End Sub


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=374411