I would like to pick a random student from a list. I will paste in new students each week, so the range may increase or decrease each time. I have command button to bring up a from, and in the form another command button to generate a random student and display that person in a label box. One problem is that the students first name is in column A and last name is in column B.
So for you Excel masters, can I get a vba code to put in the cmdGenerate button to randomly pick one student and display that student in the lblStudent box? Many thanks in advance!
Bookmarks