Help linking command button to radio option.

[qphaphakdy]

Hello,
I need some help with VBA. I have a list of three radio options and I would like to link a command button so that when a radio option is selected and the user clicks on the command button, it will direct the user to a corresponding sheet (with the same name) that is otherwise hidden.

Can someone please help?

 

[PatOBrien198]

If you have used the "Form Controls" radio button....
one of the format options is "Cell link". This cell will change when each different radio button is selected.... 1 for when the first radio created is selected, etc.
This cell could be used in an Offset function to get the name of the worksheet you want to switch to in the control button.