Userform - Auto populate multiple option button captions from spreadsheet

Hello everyone! I took a VBA class in University, so I'm not a complete rookie when it comes to working with it. However, it's been quite a while since I've had to use it and I'm stumped. I've created a user form that will build a personalized paragraph. I've set it up with multiple pages and I can easily populate list boxes with data from a spreadsheet, but as far as I can tell there's no easy way to word wrap in a list box. My workaround is to use option buttons. The issue I'm running into is automatically populating the captions based on my spreadsheet. I've attached a sample of what I'm doing. Is there an easy way to go through the option buttons in a form and give each one a unique caption based on a range in a sheet? Hopefully this is clear - feel free to ask any questions you need to clarify, and thank you for your help!

Hello welcome to the forum.
I'm not at all clear on how you wish the form to work but if you want to loop through Option buttons on a User Form and add Captions based on a range of worksheet cells then some basic code would be:

Please Login or Register  to view this content.

with your caption text in column A Sheet 1.

DBY

Thank you all for your responses. These solutions are all great, and really help me out. I like the logic in AlphaFrog's the best for my particular purpose. I really should be using that Offset function more often - I forgot how useful it is!

Thanks again! I will try paying it forward by contributing as well.