if value is more than . . . Pass otherwise Fail

[Stona]

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.

[pipoliveira]

Hi There,

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

Cheers,
Filipe

[Stona]

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

[pipoliveira]

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

[Stona]

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

[Pepe Le Mokko]

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.

[terrypin]

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.

[pipoliveira]

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

[terrypin]

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

[pipoliveira]

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

[terrypin]

Filipe: Presumably only the originator can mark this thread SOLVED?

[AliGW]

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