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!