Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marking a range True or False based on a single Checkbox
Is it possible to create a checkbox that will mark a range TRUE or
FALSE depending on the condition of the checkbox? I have a range of cells i want to mark as true or false dependent on a checkbox in a form. If you link a checkbox to a range it will only change the first cell in that range to true or false. Is this just impossible to do? Or can you maybe approach it from the other side by creating a formula in the cell such as =IF(CHECKBOX 1 = "TRUE", "TRUE', "FALSE"). I tried that and it didn't' work but the syntax may be something I'm not aware of? Thanks for your help, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marking a range True or False based on a single Checkbox
assume the range is B5:B10
link B5 to the checkbox in B6 put in =B5 drag flll down to B10. -- Regards, Tom Ogilvy "smonczka" wrote: Is it possible to create a checkbox that will mark a range TRUE or FALSE depending on the condition of the checkbox? I have a range of cells i want to mark as true or false dependent on a checkbox in a form. If you link a checkbox to a range it will only change the first cell in that range to true or false. Is this just impossible to do? Or can you maybe approach it from the other side by creating a formula in the cell such as =IF(CHECKBOX 1 = "TRUE", "TRUE', "FALSE"). I tried that and it didn't' work but the syntax may be something I'm not aware of? Thanks for your help, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marking a range True or False based on a single Checkbox
Tom, great idea, thanks!
Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
checkbox true/false label | Excel Programming | |||
Checkbox toggle true/false | Excel Programming |