[RESOLVED] Can we:- Use Option button with "if"

Hi,
I want to extract the value of a option button (radio button) using the "if" formula in excel.

The basic issue is, I don't want to enable macros and also want to know if a option button is selected or not.

Can this be done anyhow.

Thanks you
Satti Charvak

VB Code:

If Option1.Value = True 
   'it has been selected...do something
End If

Thanks Hack for your reply but I guess you haven't understood my query completely.

That was a VB code (used only for macro).

I wanted to know if something like:-

=IF(Option2.Value=TRUE,"True","False") 'A formulae based thing in a cell

works in excel.

Kind Regards
Satti charvak

Ps:- Also, if possible please move this query to office development, I've wrongly placed this in database development.

Moved

Try Using Properties\Linked Cell, set the cell to one you are not using.

Then do your test on the linked cell value.

that was very nice