Store radio button caption

Hi

I have a worksheet which has 10 multiple choice questions, all of them use radio buttons to select one and only one answer. The number of possible answers for each question varies from 2-5. I want to write a macro to step through each question in the worksheet and for each question store the caption corresponding to the selected radio button. The caption can then be stored as a string or stored in a cell, that part doesn't really matter. From what I can tell, each question and its corresponding radio buttons are grouped together with a unique groupname for each question. This may be an easy way to iterate through each question. Any help is appreciated, thanks.

Hello jaredhawco,

Welcome to the Forum!

If you can post your workbook so we can see your layout, it would be a big help. It is faster than having to post lots of questions about what type of controls you're using, where they are located, how the data is arranged, etc.

Sincerely,
Leith Ross