Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ' Fun with VBA / MS Excel!
  2.  
  3. Private Sub CommandButton1_Click()
  4. Dim mark As Integer, grade As String
  5.  
  6. mark = Int(Rnd * 100)
  7. grade = "F"
  8.  
  9. If mark <= 20 Then
  10. grade = "F"
  11. ElseIf mark <= 40 Then
  12. grade = "E"
  13. ElseIf mark <= 60 Then
  14. grade = "D"
  15. ElseIf mark <= 80 Then
  16. grade = "C"
  17. ElseIf mark <= 90 Then
  18. grade = "B"
  19. Else: grade = "A"
  20. End If
  21.  
  22. Cells(1, 1).Value = "Mark:"
  23. Cells(2, 1).Value = "Grade:"
  24.  
  25. Cells(1, 2).Value = mark
  26. Cells(2, 2).Value = grade
  27.  
  28. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement