Hi. This is probably easy stuff, but I can't seem to do it!

Here goes...

I have a form that contains several OptionButtons. These are all held in a frame on my UserForm. There are also Labels in the frame next to the OptionButton that identifies its purpose to the user.

I would like to find a way of iterating through the frame to identify which OptionButton has been selected. Then, using the associated Caption of the OptionButton I would like to enter this value into a cell on a worksheet.

I've been having real trouble with this. I'm just trying to do a project for work that will really make my life easier there, I'm not an Excel superuser!

If anyone can help I'd be real grateful.

Thanks,

Rob.