Option Button selection into column

Hello all! I need just a little finish work. I need the option button value ("StateName") to be placed in the selected cell (that will be in column "B"). I think I'm close I just can't get the rest of the way. The frame with the option buttons is on the form "frmCommits" and I don't know how to relate the code here to that form. This code is in a module.

I also need to know if this code will automatically go to the active sheet or do I need to name it? (I have several sheets in my workbook.)

Please Login or Register  to view this content.

Thank you, thank you!