CheckBox help

[Ant12345]

Can i get some help please for the use of a checkbox in excel 2003.
I want cel a1 to show the value of 1 when checked and the value of 0 when unchecked. Thank you

 

[Makrini]

Depends what checkbox you are using

From the "forms" toolbar one..

Right click - format control - control tab and choose a cell to "link" (i.e B1)


From the "Control" toolbar

Right click - properties - and type "B1" into "linked Cell"



This will make True or False in the Cell

Then in A1 type

=--B1

Which will turn the True/False to 1 or 0

 

[Ant12345]

Ty for help Makrini works well, is there a limit on how many check boxes i can use on a sheet? Thank you

 

[diddi]

not that i know of, but maybe its worth making a userform to do your job instead. it will prolly look a lot neater