Thread: Formatting Textbox, passing values to worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_226_] Leith Ross[_226_] is offline
external usenet poster
  
Posts: 1
Default Formatting Textbox, passing values to worksheet

Hello Craig,

You were pretty close to solving the problem. Just move the Format
statement into the TextBox's After_Update event. Use "Currency" for
money formatting because it is internationally aware.


Code:
--------------------

Private Sub TextBox1_AfterUpdate()

TextBox1.Text = Format(TextBox1.Text, "Currency")

End Sub

--------------------

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482423

Reply With QuoteReply With Quote