Posted to microsoft.public.excel.programming

Shailesh Shah[_2_] Shailesh Shah[_2_] is offline

external usenet poster

Posts: 114

textbox.caption question

Try this,

UserForm1.Label1.Caption = Format(Round(Cells(1, 1), 2), "#,###.00")

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
TextBox Question	Jim	Excel Discussion (Misc queries)	4	July 11th 08 10:41 PM
Textbox question	browie	Excel Discussion (Misc queries)	0	June 13th 05 04:00 PM
Textbox.caption to cell if empty, how?	WTG	Excel Worksheet Functions	1	February 27th 05 09:30 AM
Textbox.caption to cell if empty, how?	WTG	Excel Discussion (Misc queries)	2	February 27th 05 04:03 AM
Textbox question	Jorge Rodrigues[_2_]	Excel Programming	4	November 13th 04 11:08 PM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us