Macros and IF Functions

K

Keri

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
 
B

Bernie Deitrick

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
 
Top