How do I link a check box to a macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and move check box (check boxes) with new cell link? 1
Formula Based On a Check Box 2
VBA for form check boxes 4
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Linking more then one cell to a Check Box 1
Check Boxes 1
Use of Check Boxes 1
Conditional Formula Based On A Check Box 1

Back
Top