Macros and IF Functions

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

Hello,

Does anyone know if I can use a Macro checkbox as a
condition of an IF function? For instance if the box is
checked display "Blue" in A1. Or if I can't use Macros in
an IF statement, is there another way to get the same
result. Thanks,

--Keri
 
If you use a checkbox from the Control Toolbox, there is a
property called "LinkedCell" (while in design mode, right
click the checkbox and choose Properties). Type in
something like "C1" (no quotes) for LinkedCell. If the
checkbox is checked, C1 will display TRUE. If not, it will
display FALSE. From here, you could use a formula in A1:

=IF(C1=TRUE,"Blue","")

or shorter:

=IF(C1,"Blue","")

HTH
Jason
Atlanta, GA
 
Back
Top