Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I link a check box to a macro?
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. |
#2
|
|||
|
|||
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 -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link an excel macro from my web page? | Excel Discussion (Misc queries) | |||
Unable ot Break link for Macro with no source | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
How do I link a macro to an ActiveX control? | New Users to Excel | |||
How do I link a macro to an ActiveX control? | New Users to Excel |