+ Reply to Thread
Results 1 to 10 of 10

problem show correct number in textboxes on form contains number format

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    problem show correct number in textboxes on form contains number format

    Hello,
    I try to make project to show numbers format in textboxs , but for some reason doesn't show amounts correctly for each textbox.
    my goal when fill textbox1,3 will fill the rest of textboxes based on formulas as inside the code and showing number format like this "#,##0.00"
    also I would show mark "%" in textbox4 when show value .
    I hope some body help.
    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,325

    Re: problem show correct number in textboxes on form contains number format

    See if this is the way you wanted it...Complete 1 and 3...
    Attached Files Attached Files
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: problem show correct number in textboxes on form contains number format

    thanks .
    I'm afraid textbox5 doesn't show result correctly !
    example: textbox1=20,000.00, textbox2=5.00 , textbox4=20.00% so the correct result should be 3,200.00 , not 320,000.00 . I see multiplying 20.00 without take consideration %. when multiply 20.00 should divide by 100 to show the correct right.
    based on my formula should subtract textbox1-textbox2 first of all ,after show result should multiply value in textobox4
    by the way the formula should be like this
    Please Login or Register  to view this content.
    not as you did
    Please Login or Register  to view this content.

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,325

    Re: problem show correct number in textboxes on form contains number format

    Well...I had no examples to test against as none were given...
    Please supply sample entries for 1 and 3 and tell me expected result in 2,4 and 5...

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: problem show correct number in textboxes on form contains number format

    textbox1=20000
    textbox3=5
    result
    textbox2=4,000.00
    textbox4=20.00%
    what I want in textbox5=3,200.00 (formula=(20,000.00-4,000.00)*20.00%=3,200.00)
    about 20.00% after subtraction should be 16,000.00 *20.00/100 to show 3,200.00

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,325

    Re: problem show correct number in textboxes on form contains number format

    Thank you...Here you go...

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: problem show correct number in textboxes on form contains number format

    thanks again,
    but why if I change the value in textbox3 will show problem again about number formatting when the form is open .
    first picture is correct, second picture when change value in textbox3 to 10 will show problem again.
    Attached Images Attached Images

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,325

    Re: problem show correct number in textboxes on form contains number format

    And the plot thickens...
    One would assume you process to sheet and then form gets cleared to re-populate again...
    Perhaps be a bit more transparent next time in your requirement...
    Attached Files Attached Files
    Last edited by Sintek; 10-12-2024 at 05:36 AM.

  9. #9
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: problem show correct number in textboxes on form contains number format

    Perhaps be a bit more transparent next time in your requirement...
    sorry !
    I thought this step is normal , so I don't mentioned in OP .
    thank you so much.

  10. #10
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,325

    Re: problem show correct number in textboxes on form contains number format

    All good...Happy Coding...Tx for rep +

+ 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] what I need to show number with currency after calculation between textboxes on userform
    By Ali-M in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-28-2022, 05:57 AM
  2. [SOLVED] Breaking down a number into its correct format
    By sungen99 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-07-2019, 11:55 AM
  3. [SOLVED] Display correct number format
    By Aland2929 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-03-2018, 07:09 AM
  4. [SOLVED] Change Number format of textboxes in simple way
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2017, 02:03 PM
  5. Correct text number to excel number format?
    By domgilberto in forum Excel General
    Replies: 9
    Last Post: 09-11-2015, 05:39 PM
  6. Replies: 0
    Last Post: 02-10-2015, 04:39 AM
  7. Replies: 1
    Last Post: 05-18-2006, 11:45 PM

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