Shuffle values in userform textboxes

Occasional 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


How to Shuffle Cells in Excel

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