Results 1 to 3 of 3

Possible to have number formatting in TextBox?

Threaded View

  1. 04-27-2010, 07:09 AM #1
    Carlsbergen
    Carlsbergen is offline
    Registered User
    Join Date
    05-12-2009
    Location
    Udevalla, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    85

    Possible to have number formatting in TextBox?

    Hi guys.

    I have just created a UserForm with some textboxes in it.

    In the UserForm_Activate I have written some code that fills in the textboxes
    with data from my sheet.

    Like so.

    TextBox2 = ActiveCell.Offset(0, 23).Value
    What I was wondering is if it is possible for the textbox to show the value with
    some number formatting. Particularly I want no decimals and I want to use 1000 separator.

    Anyone have any ideas?
    Last edited by Carlsbergen; 04-27-2010 at 08:50 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1