mardi 20 juillet 2021

Random pick cycle from an array in VBA

I'm new in VBA. I want to make a random pick cycle like that:

Let's say I have seven elements in an array(1,2,3,4,5,6,7), each time when I pick one element from the array, the total number of elements will decrease by 1. After picking every element, the array will be reset to what I initially defined (1,2,3,4,5,6,7) and do the random pick cycle again. The result of every cycle should be different.

Is it possible to do that in VBA?




Aucun commentaire:

Enregistrer un commentaire