Choose Random Element

Copper Contributor

Hi all,


I have a userform with 5 buttons and 5 text boxes.


When I press the button, I'd like the caption from the button to be pasted into a RANDOM text box of the five. If one of the text boxes already has some text in, it must not choose it.


I have no idea how to achieve this! I've seen random number generators for cell formulas, but cannot think of a way to integrate that into this.


Any advice would be grand!



0 Replies