Plan ahead: name the controls to include their location.

Eg. opt_B2

Then you can get the control's (intended) location directly from its name
using

dim rng as range
set rng=shtObject.range(split(controlname,"_")(1))

Tim


"SupperDuck" wrote in message
...
Hello,

For example I have 400 option buttons, so i want to find on which cell
they
are.

I mean, if option button is on cell (2,2) I want to know this.

Is it possible?

Regards,