Posted to microsoft.public.excel.misc

PAS

external usenet poster

Posts: 26

TextBox format?

I am trying to format a textbox and I'm using to following code:

Private Sub TextBox1_Change
TextBox1.Value = Format (TextBox1.Value, "###0")
End Sub

But nothing happens......Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to format text in textbox?	ghost	Excel Discussion (Misc queries)	1	May 18th 08 10:41 AM
TextBox format?	AOU	Excel Discussion (Misc queries)	4	June 12th 07 11:24 PM
Textbox date format.	AOU	Excel Discussion (Misc queries)	2	April 24th 07 02:28 PM
TextBox Format	grahammal	Excel Discussion (Misc queries)	3	March 29th 06 01:35 PM
Format numbers in Textbox	stickandrock	Excel Discussion (Misc queries)	1	October 4th 05 08:41 PM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us