Using a Option button to call a Sub

[ccschaad]

hello,

I am trying to make an excel spreed sheet that will always be adding more option buttons in sets of six. Each Set of six will be doing basicly the same thing just one row below the last. Is there any way to assign a option button to call a different fuction step1_Click instead of name_Click? In other words all option buttons 1's will call step1_Click, all option buttons 2's will call Step2_Click.

Thanks

[e-mail]

[AndreRet]

Have a look at this link with sample code for various options in excel

[ccschaad]

Thanks ,but the code in your link dose not exactly fit my needs. I can use it see which option buttons are selected. What I am looking for something that when the option button is click it automatically changes the state of select cells. I have the code made that can do this but I need the spread sheet to create multiple option buttons and assign them to a macro