R
rob
Use a VB form. Turn of the forms toolbar by clicking
rools.. cutomize and checking the forms toolbar. You will
see a checkbox ont the bar. click it and put a checkbox
in your sheet. Edit the properties of the checkbox to
give it a cell reference to a cell of your choice. Now,
that cell will be FALSE if the box is not checked, and
TRUE if it is. Using this and excel's IF statement or by
other means. you can put that check box to work. Let me
know if this helps...
rools.. cutomize and checking the forms toolbar. You will
see a checkbox ont the bar. click it and put a checkbox
in your sheet. Edit the properties of the checkbox to
give it a cell reference to a cell of your choice. Now,
that cell will be FALSE if the box is not checked, and
TRUE if it is. Using this and excel's IF statement or by
other means. you can put that check box to work. Let me
know if this helps...