recording option button values?

[humboldtguy]

I am sure this is easy for anyone who knows what they are doing, but I can't figure out how to post the results of a userform option button to my worksheet. Have never done it before, I found the following code by searching google

Please Login or Register  to view this content.

but I don't know how to fit it in with my current code....can someone educate me?? thanks in advance...here is my current code

Please Login or Register  to view this content.

[royUK]

Possibly

Please Login or Register  to view this content.

[humboldtguy]

Thanks for the quick reply Roy, for some reason it did not work though. Here is what I ended up with.....Any idea's why it doesn't work?? thanks again guys

Please Login or Register  to view this content.

[humboldtguy]

oops, it works, thank you Roy!!! I had the names wrong for my option buttons, my bad, thank you so much to the best excel forum on the web!!!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save