Help require in lookin for option button click event code.

[aligahk06]

Dear All,

I am attaching a file for your reference.
Please assist me as i want to look the option button click event code.

Can any body assist me to accomplish my task.

Help is deeply welcome.
I do appreciate your time and value.

Rgds,
Aligahk06

[Bob Phillips]

Optionbuttons have a click event associtaed with them.

Goto the worksheet code module and use code such as

[vba]

Private Sub OptionButton4_Click()
'do your stuff
End Sub
[/vba]