checkboxes
Posted by brettsouth on December 16, 2001 11:14 PM
I recently picked up a spread sheet from Tec republic web site with check boxes through out the spread sheet.ticking the box returns true in a cell specified, how can i format these in subh a manner that they return a specific statement rather than true or false?
Posted by Aron on December 17, 2001 12:42 AM
This may be too simple for your form, but you could select another cell, and use an if() function. For example; =if(cellChangedByCheckBox="True","Text you want to appear when true.","Text you want to appear when false.")
(Hope that made sense. I'm sure there's a better way, but this should work.
