Hi, I'm a newbie to VBA
I have a list of participants who've each had 0 to 5 attempts at an event and a list of scores obtained.
Suppose a participant has had 2 attempts, I have to randomly choose 2 scores from the list given.
If one has had 3 attempts, I have to randomly choose 3 scores and so on.
How do I proceed ? Thanks
One way
Please Login or Register to view this content.
Hi Le_Kev,
Here's my attempt (though I'd use jindon's) - it will put each random number in a message box for every participant (adapt to your own needs) whose No of attempts is greater than zero:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thanks for your replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks