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

[satti charvak]

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

[Hack]

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

[satti charvak]

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.

[si_the_geek]

Moved

[VB4fun]

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

Then do your test on the linked cell value.

[satti charvak]

that was very nice