Need VBA help to randomly assign order to items

[wcassell]

I'm working on a simulation program and I need help with some code to assign an order for each of the items. For example, if I have 6 items in my list. I want the code to choose which one gets selected 1st, 2nd, 3rd . . .

My Item - Order(selected by code)
Item1 - 2nd
Item2 - 5th
Item3 - 4th
Item4 - 6th
Item5 - 1st
Item6 - 3rd

Thanks

 

[Zathras]

Do a search for "random" or take a look at my "RandomRank" function in thread68-611983