VBA: Select row and press button to store in a variable

[VBANEWBIE12345]

I got this assignment, which i can't figure out.
I have tried to use array, but i can't really get it right in VBA.

The assignment:

"You must now create a function/sub that is activated by a button in Excel. When the user has
selected a row and presses the button, the expected grade of the student must be stored in a
variable. The function/sub must be able to be run any number of times on any number of rows. The
user must then be able to press another button that will show the average grade from the selected
rows."

Any kind of help is useful
Thank You

 

[mumps]

Hello @VBANEWBIE12345 and welcome to the Forum. This sounds like a homework assignment. Forum members are here to help but generally, they will not help to do an assignment for you. Could I suggest that you do a little research online related to your assignment. There is a great amount of information that will guide you in the right direction.