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

VBANEWBIE12345

New Member
Joined
Mar 10, 2018
Messages
1
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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,588
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,251
Messages
5,527,636
Members
409,778
Latest member
MagalieD

This Week's Hot Topics

Top