linking groups of option buttons in different worksheets

[jeff.nglc]

VB beginner here -
I have two worksheets in a single Excel file. They are each an invoice and they will both be linked to the same customer, so I want to be able to fill out one and have almost all of the information to transfer to the other.

I know how to call information from a cell in another worksheet, but I also want option buttons that are selected on the first worksheet to automatically select their corresponding buttons on the second worksheet. Is there a way to do this in VB? I have only used VB a little, so I might need a little explanation on how to do this exactly. I have seen a similar question in this forum from the post "Radio Buttons Selecting Other Radio Buttons" from September 2007 (sorry, I don't know how to find the post id to link to the post) and here is the code that user Neonate928 came up with:

Please Login or Register  to view this content.

Can anyone explain this to me? Or help me figure out another way to have a group of option boxes mirror another group from another worksheet? I've been at this for a while and can't figure out what to do. Thanks a ton in advance for the help.

[mudraker]

Have a look at

http://www.excelforum.com/showthread.php?t=627282

It deals with Check boxes, but the principle is the same.

[jeff.nglc]

mudraker, you're awesome. Thanks for the help! (even though it's just a simple little thing - a lot easier than I expected). I've got it doing what I need it to do now. I appreciate it, tons.