Shuffle values in userform textboxes

Copper Contributor

Hello, I've been trying to rack my head around this problem for a few weeks now and haven't got anywhere near a solution.

 

I have a userform with 5 textboxes (for names) and a "shuffle" button. After the user has added names to the 5 textboxes, I'd like them to be able to press the shuffle button which would randomise the names across the 5 textboxes (i.e. the name in box1 moves to box4, etc).

 

Is this possible to do?

 

Thank you.

1 Reply

@MikeWells13 

How to Shuffle Cells in Excel

Maybe the link above will help you a little further in your plans :).