Check boxes have a property Linked cell where the links cell will havvew a
value True or False.  You can set the lijnked cell either through the
worksheet or VBA.

To set the link cell on the worksheet you need to get into design mode and
change the check box property.

1) view Menu - tool Bars - Control Tool box
2) On toolbar press triangle (Design Mode)
3) Press Property on tool bar (next to triangle).
4) Press Check box.  On properrty window set LinkCell to a cell like A1.
5) Exit Design mode by pressing triangle again.  Now when you check and
uncheck the check box the linked cell will automatically change.

Thanks
Actually i need to have some cells appear when i checked the box so that i
can put my values in the appeared cell.