Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

Checkbox Value Change

Posted by Damien O'Donnell on June 19, 2001 4:38 PM

: using a check box to reformat a worksheet is great you simply check the value of the check box using vb code

Re: Checkbox Value Change

Posted by gregc on June 19, 2001 8:41 PM

I am not sure if this is what you are looking for, but you can put some way out cell value to 1 or 0 and depending on its value that is what the checkboxvalue is. Example: If range("a5500") = 1 then
checkbox1.value = true
else checkbox1.value = false
end if

and then run your code.
Help??

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.