LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default View Numbers in Textbox in Proper Format in UserForm


Hi,

I have one Userform having Textbox2 to show the Value of the Total
amount from the worksheet.

I mean in Sheet1, B3 there is written 34,540.00 and I want to
show this value exactly in UserForm,

I connected to the textbox2 in UserForm, but my problem is this, it
is showing like this 34540.00 this is not proper format.

it should be 34,540.00 (with comma).

Kindly advise me how fix this problem.

Thanks and regards.

Shahzad
Madinah
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How2 accept only numbers in userform textbox MARTY Excel Programming 9 January 5th 08 05:47 AM
Format TextBox on UserForm ryguy7272 Excel Programming 7 August 5th 07 03:46 PM
Max numbers of characters in userform textbox and cell N E Body Excel Programming 4 June 27th 05 06:25 PM
format textbox in userform jeffP Excel Programming 1 January 25th 05 01:10 AM
Format of a TextBox in a userform MD Excel Programming 4 January 13th 05 05:42 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"