+ Reply to Thread
Results 1 to 10 of 10

userform percent

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    userform percent

    PAJAKxx.xlsmDear All,

    Please help me for solved my problem about percent, when i'm type 1 in my userform but my excel result become 100% (column P)

    Please Login or Register  to view this content.
    My second question, can my userform have looking % in my textbox.disc1


    Thanks - John

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,182

    Re: userform percent

    You need to divide the contents of the textbox by 100 before populating the cell
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: userform percent

    Quote Originally Posted by Andy Pope View Post
    You need to divide the contents of the textbox by 100 before populating the cell
    Hello Andy,

    I'm searching many about userform and find example

    Please Login or Register  to view this content.
    or this

    Please Login or Register  to view this content.
    sorry ... but i'm not have basic VBA how to put this code or combine.


    Thanks - John
    Last edited by johnreid7477; 05-28-2013 at 11:52 AM.

  4. #4
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: userform percent

    Please Login or Register  to view this content.
    help ...
    Last edited by johnreid7477; 05-28-2013 at 07:27 PM.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,182

    Re: userform percent

    This will output to the sheet as percentage value.

    Please Login or Register  to view this content.
    It assumes the output cell is already formatted to display percentages.

  6. #6
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: userform percent

    Quote Originally Posted by Andy Pope View Post
    This will output to the sheet as percentage value.

    Please Login or Register  to view this content.
    It assumes the output cell is already formatted to display percentages.
    Thanks for reply Andy

    my new code now

    Please Login or Register  to view this content.
    But can you help me fix my code, why if i'm blank one ....value userform my code become error "13" and yellow for
    Please Login or Register  to view this content.
    Bill Rockenbach help me too and give me additional code (i'm put in uppper)
    Please Login or Register  to view this content.
    Please check my excel attachment

    Thanks
    Attached Files Attached Files

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,182

    Re: userform percent

    I don't see any posts by Bill Rockenbach in this thread. Have you posted you question on other forums?

  8. #8
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: userform percent

    Bill posted here: http://www.ozgrid.com/forum/showthread.php?t=178986 - and the examples 'found' by the OP were supplied by him.

    In other words - cross posted.
    Last edited by cytop; 05-29-2013 at 05:05 AM.

  9. #9
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: userform percent

    Quote Originally Posted by Andy Pope View Post
    I don't see any posts by Bill Rockenbach in this thread. Have you posted you question on other forums?
    yes but no answer... before you give clue
    Please Login or Register  to view this content.
    i'm using
    Please Login or Register  to view this content.
    i'm sorry if break rules excelforum.


    Thanks

  10. #10
    Registered User
    Join Date
    02-20-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: userform percent

    Nightmare only userform percent break rules lol.

    Thanks for help Andy Pope.

    Please Login or Register  to view this content.
    Thread Close "Done"
    Attached Files Attached Files

+ 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