Referring to Option Button in If then statement

[Mike]

I'm sure this is a very basic question, but I can't seem to find the answer
in Excel Help. How to I reference an option button in an if then formula?

Any help would be appreciated.

Mike

 

[Dave Peterson]

You can link the optionbutton to a cell and then use that cell in your formula.

If the optionbutton is from the Forms toolbar:
rightclick on it
choose Format Control|Control Tab
and type in an address into that Cell link box.

If the optionbutton is from the Control toolbox toolbar, then go into design
mode (also on that same toolbar).

Then rightclick on it and choose properties and change the LinkedCell property.

 

[Mike]

You can link the optionbutton to a cell and then use that cell in your formula.

If the optionbutton is from the Forms toolbar:
rightclick on it
choose Format Control|Control Tab
and type in an address into that Cell link box.

If the optionbutton is from the Control toolbox toolbar, then go into design
mode (also on that same toolbar).

Then rightclick on it and choose properties and change the LinkedCell property.

 

[Mike]

It worked!

Thanks Dave.

You can link the optionbutton to a cell and then use that cell in your formula.

If the optionbutton is from the Forms toolbar:
rightclick on it
choose Format Control|Control Tab
and type in an address into that Cell link box.

If the optionbutton is from the Control toolbox toolbar, then go into design
mode (also on that same toolbar).

Then rightclick on it and choose properties and change the LinkedCell property.