View Single Post
 
Old 08-23-2015, 09:03 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

What part of this do you need a macro for?

Put a Form Controls Checkbox on B5
In the check box properties make the linked cell B5. Format B5 text same color as back ground so it's not distracting.
Put formula in C5 =IF(B5=TRUE,E5,"")
Reply With Quote