+ Reply to Thread
Results 1 to 3 of 3

Userform textbox number formats

  1. #1
    PhilM
    Guest

    Userform textbox number formats

    Hi

    I need to set the number format of a textbox (in a userform) to show a
    percentage. How do go about this?


  2. #2
    Harald Staff
    Guest

    Re: Userform textbox number formats

    Hi

    Dim D As Double
    D = 418 / 1300
    TextBox1.Text = Format$(D, "0.0%")

    HTH. Best wishes Harald

    "PhilM" <[email protected]> skrev i melding
    news:[email protected]...
    > Hi
    >
    > I need to set the number format of a textbox (in a userform) to show a
    > percentage. How do go about this?
    >




  3. #3
    PhilM
    Guest

    Re: Userform textbox number formats


    Harald Staff wrote:
    > Hi
    >
    > Dim D As Double
    > D = 418 / 1300
    > TextBox1.Text = Format$(D, "0.0%")
    >
    > HTH. Best wishes Harald
    >
    > "PhilM" <[email protected]> skrev i melding
    > news:[email protected]...
    > > Hi
    > >
    > > I need to set the number format of a textbox (in a userform) to show a
    > > percentage. How do go about this?
    > >


    Spot on, thanks Harals


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1