MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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.