I have a userform to conduct a multiple choice test. Test will have 20 questions. It is working fine when questions are populated in a definate order. But I want to pick random questions from set of 20.
I am able to resolve the part of generating random numbers. I am generating 20 numbers in random order from series of 1 to 20 in 20 individual textboxes on excel userform. (these boxes will be hidden)
I want to get value in a textbox from multiple textboxes but one at a time on click of a command button.
Textbox41 to pick value from textbox21 on click of Start button.
On click of Next, Textbox41 to pick value from textbox22. And everytime next button is clicked Textbox41 to pick value from next textbox.
Any suggestions on the best way to do this? Does anyone have a good example I can replicate or feel like coming up with some code?
Any help someone could offer would be very much appreciated!