Given a test score in A1, I have to create a command button that will assign the word "Pass" or "Fail" to cell B1. Pass is a score of 60 or greater, and Fail is a score of less than 60.
I have some code started such as:
Score = Range("A1").Value
If Score <60 Then
Result = "Fail"
Else
Result = "Pass"
End If
I just wanted to know if this would satisfy my conditions.
Hi,
Yes, it would work.
Other option:
Please Login or Register to view this content.
Last edited by GC Excel; 11-02-2018 at 12:28 PM.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Please Login or Register to view this content.
The essence of the code is correct but not the syntax. Something like
Of course you don't actually need a macro. A simple function in B1 would be betterPlease Login or Register to view this content.
i.e.
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks