Hi,
I'm looking for a way to randomize listbox items after pressing a button. The listbox has 3 columns : 1/ entries number 2/ male name 3/ female name. Columns 2 and 3 always come together, so when one item moves up or down, the other is moving along.
Example:
After pressing the Randomize button we should get something like this:
Todd and Britney randomly moved from the 1st position to the 11th but they're still together. Same thing for the other couples.
The xlsm can be downloaded there:
UserForm.xlsm - 0.03MB
Thanks in advance!
I'm looking for a way to randomize listbox items after pressing a button. The listbox has 3 columns : 1/ entries number 2/ male name 3/ female name. Columns 2 and 3 always come together, so when one item moves up or down, the other is moving along.
Example:
Code:
01 Todd Britney
02 Jimi Meredith
03 Serge Amy
04 Richard Kim
05 Roger Gabrielle
06 Mike Tammy
07 Bill Jill
08 Jim Joyce
09 Phil Judy
10 Bebel Jules
11 Fredrik Helen
12 James Yolanda
After pressing the Randomize button we should get something like this:
Code:
01 Serge Amy
02 Jim Joyce
03 Fredrik Helen
04 Mike Tammy
05 Jimi Meredith
06 Bill Jill
07 Roger Gabrielle
08 Phil Judy
09 Richard Kim
10 James Yolanda
11 Todd Britney
12 Bebel Jules
Todd and Britney randomly moved from the 1st position to the 11th but they're still together. Same thing for the other couples.
The xlsm can be downloaded there:
UserForm.xlsm - 0.03MB
Thanks in advance!