+ Reply to Thread
Results 1 to 12 of 12

if value is more than . . . Pass otherwise Fail

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    92

    if value is more than . . . Pass otherwise Fail

    Good day again

    Im uploading a macro file and i want to know if this can be done

    if the value in TextBox11 (result in %) is greater than 79, indicate the word "Pass" in another textbox or label that you can create anyone on the userform.


    this vba calculator only uses textboxes and no excel workbook.

    the word pass can be in red lettering.
    Attached Files Attached Files

  2. #2
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Re: if value is more than . . . Pass otherwise Fail

    Hi There,

    Please check attached file and let me know if that's what you're looking for.

    Cheers,
    Filipe
    Attached Files Attached Files


    * If a reply solved or answered your query/question, you can add reputation to the person by clicking on the * Add Reputation
    * When question is resolved, please mark your thread as SOLVED


    Thanks and regards,
    Filipe Oliveira

  3. #3
    Registered User
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    92

    Re: if value is more than . . . Pass otherwise Fail

    hi thank you its what i wanted but what if he gets less than 79, then it must show "Fail"

    and how do u make Label5 not to show until the result is in textbox11
    Last edited by Stona; 02-13-2020 at 08:19 AM.

  4. #4
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Re: if value is more than . . . Pass otherwise Fail

    Sorry about that, missed that one.

    Check the attached file.

    I've added code to change label colour to red if value is 78 or less and green to 79 or higher.

    Let me know if that worked for you.

    Cheers,
    Filipe
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    92

    Re: if value is more than . . . Pass otherwise Fail

    thank you very much!!!!!!!!!!

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,687

    Re: if value is more than . . . Pass otherwise Fail

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  7. #7
    Forum Contributor
    Join Date
    01-06-2010
    Location
    East Grinstead, UK
    MS-Off Ver
    MS Office 365
    Posts
    497

    Re: if value is more than . . . Pass otherwise Fail

    What am I missing here please!

    I'm logged in. I opened the file Book1.xlsm and made it available for editing - but it appears to have no content. Same with both the original and the answer.

    EDIT: Other files I tried were all OK.
    Last edited by terrypin; 02-13-2020 at 11:27 AM.
    Terry, East Grinstead, UK
    Excel 365, Win 10 Pro, i7 PC, 4.0 GHz

  8. #8
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Re: if value is more than . . . Pass otherwise Fail

    On sheet 1 you do not have anything to show the UserForm.
    You needed to go to Visual Basic Editor to call out the form.
    To make things easier, I have inserted a command button in sheet1 to open the userform.
    See if that helps.
    Cheers,
    Filipe
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    01-06-2010
    Location
    East Grinstead, UK
    MS-Off Ver
    MS Office 365
    Posts
    497

    Re: if value is more than . . . Pass otherwise Fail

    Thanks, got it. Didn't think of looking in the Forms section.

  10. #10
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Re: if value is more than . . . Pass otherwise Fail

    No worries,
    If no further assistance is required, please do the following:
    If my reply solved or answered your query/question, please click on the * Add Reputation
    When question is resolved, please mark your thread as SOLVED.
    Many thanks in advance and kind regards,
    Filipe

  11. #11
    Forum Contributor
    Join Date
    01-06-2010
    Location
    East Grinstead, UK
    MS-Off Ver
    MS Office 365
    Posts
    497

    Re: if value is more than . . . Pass otherwise Fail

    Filipe: Presumably only the originator can mark this thread SOLVED?
    Attached Images Attached Images
    Last edited by AliGW; 02-15-2020 at 10:10 AM. Reason: Please don't quote unnecessarily!

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,051

    Re: if value is more than . . . Pass otherwise Fail

    @ Terry - yes, but so can mods and admins.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. Help with Pass/Fail Problem
    By clooysen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2016, 09:39 PM
  2. Pass or fail?
    By anri.scooter in forum Excel General
    Replies: 4
    Last Post: 07-21-2015, 03:38 AM
  3. PASS or FAIL
    By HansWitt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-18-2015, 06:00 AM
  4. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  5. [SOLVED] Pass And Fail
    By thong127 in forum Excel General
    Replies: 9
    Last Post: 06-11-2013, 05:17 PM
  6. If <> Then pass , otherwise fail help needed
    By Nero_slk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:11 AM
  7. [SOLVED] pass fail
    By Tricia in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-20-2005, 12:06 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