Hello!

I have used in VBA (excel 2000) 3 option buttons, which are grouped. Currently, one of them is clicked and the data connected to it are correct.
The problem is that if I make a change in a cell, the data are NOT re-calculated. I have to click another option button, and then re-click the one I want and only then the data become correct again.

So the point is: Is there a way to make the option button to re-calculate the data, whenever ANY change occurs in the current sheet? Something like "onchange"...

Please help !!
Thanks!!