+ Reply to Thread
Results 1 to 8 of 8

User Form texbox calculation to return % icon after value.

  1. #1
    Forum Contributor
    Join Date
    06-03-2014
    Location
    South-Africa
    MS-Off Ver
    2010
    Posts
    133

    User Form texbox calculation to return % icon after value.

    Hi There...

    I have a user form where numerical entries are entered. When pressing the command button the sheet then calculates a value to 2 decimals. I need it to show the % value after the returned calculation. See code below.

    Please Login or Register  to view this content.
    Any one know what needs to be added?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: User Form texbox calculation to return % icon after value.

    Please Login or Register  to view this content.
    You need to alter the calculation slightly by removing the "*100", but that's how you get the percentage format.
    Last edited by BadlySpelledBuoy; 12-04-2014 at 06:42 AM.

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: User Form texbox calculation to return % icon after value.

    Just use the percentage symbol, ie "0.00%"
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Forum Contributor
    Join Date
    06-03-2014
    Location
    South-Africa
    MS-Off Ver
    2010
    Posts
    133

    Re: User Form texbox calculation to return % icon after value.

    Quote Originally Posted by BadlySpelledBuoy View Post
    Please Login or Register  to view this content.
    You need to alter the calculation slightly by removing the "*100", but that's how you get the percentage format.
    Works perfect Tks!

  5. #5
    Forum Contributor
    Join Date
    06-03-2014
    Location
    South-Africa
    MS-Off Ver
    2010
    Posts
    133

    Re: User Form texbox calculation to return % icon after value.

    Quote Originally Posted by Trebor76 View Post
    Just use the percentage symbol, ie "0.00%"
    Works perfect Tks!

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: User Form texbox calculation to return % icon after value.

    Happy to help. Thanks for the Rep point.

    BSB.

  7. #7
    Forum Contributor
    Join Date
    06-03-2014
    Location
    South-Africa
    MS-Off Ver
    2010
    Posts
    133

    Re: User Form texbox calculation to return % icon after value.

    Pleasure! Was a deserving point.

  8. #8
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: User Form texbox calculation to return % icon after value.

    Yes, thanks Colin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] showing message box if the result of texbox doesn't match with the range then clear texbox
    By hamidrezaxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 01:04 PM
  2. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  3. VBA Login Form and TexBox Validation
    By Harry1302 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2012, 06:14 PM
  4. Calculation in User Form
    By mal.b.graham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 09:39 AM
  5. Form: texbox navigation
    By nglow in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2009, 09:12 AM

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