Referring to Option Button in If then statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 17 May 2008 05:15 GMT

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

Reply to this Message

Dave Peterson - 17 May 2008 12:55 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

Mike - 17 May 2008 15:44 GMT

> You can link the optionbutton to a cell and then use that cell in your formula.
>
[quoted text clipped - 14 lines]
> >
> > Mike

Reply to this Message

Mike - 17 May 2008 15:44 GMT

It worked!

Thanks Dave.

> You can link the optionbutton to a cell and then use that cell in your formula.
>
[quoted text clipped - 14 lines]
> >
> > Mike

Reply to this Message