Macros and IF Functions
 

Hello,

Can anyone tell me if I can use a Macro check box as
logical text in an IF function? For instance if the box
is checked A1 should display "Blue". If I can't use
Macros in an IF statement, is there another way to get the
same results? Thanks,

--Keri

Macros and IF Functions
 

Keri,

You could use the checkbox from the forms commandbar, and link it to a
cell - right click on the checkbox, select "Format Control...", then click
on the Control tab, and select a cell for the cell link. For example, use
cell A2, formatted for custom ";;;" (which is hidden). Then in A1, you can
use the formula

=IF(A2,"Blue","")

HTH,
Bernie
MS Excel MVP

"Keri" wrote in message
...
Hello,

Can anyone tell me if I can use a Macro check box as
logical text in an IF function? For instance if the box
is checked A1 should display "Blue". If I can't use
Macros in an IF statement, is there another way to get the
same results? Thanks,

--Keri