How do I link a check box to a macro?

T

Tom

I would like to set up a form that provides instructions/comments based on
"check boxes" checked on a questionairre. If a user checks a box next to "My
house is white" then I want "Boarders can be any color" to show in a comments
field. Any ideas? Ideally this would be an Excel document. Thanks for the
help.
 
B

Biff

Hi!

Assume the following:

A4 = My house is white
B4 = checkbox
C4 = linked cell to checkbox (will display either TRUE or
FALSE)
D4 = formula:

=IF(C4=TRUE,"Boarders can be any color","")

You can either set the font color of cell C4 to be the
same as the fill color (to hide the TRUE or FALSE) or,
just hide column C altogether.

Biff
 
Top