Hello,
In fact I have something similar to the workbook you want (I'm a trainer and I'm using this for rating my students), so in fact I have to adjust this to your needs. I suppose you want not to type in the questions (as you wrote in the post) but instead to have a randomly selected set of pre-written questions along with their possible answers, copied to a new sheet, adding the necessary radio buttons and copying the correct answers to a hidden sheet.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA macros, of almost any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini