Adding & Subtracting Using Checkboxes

[bickersc]

I am creating a inventory spreadsheet for when we order parts and when they arrive. When they are ordered I want to be able to subtract them from the total and when they arrive I want to be able to add them to the total. If possible, I would like to be able to use a checkbox from the developer tab / using the format control true & false.

 

[Jeffrey Mahoney]

I'm not a big fan of the ActiveX or Form checkboxes. They are kind of too much work, especially when there are a lot of them.

Do you have the NEW!!! checkboxes under the Insert menu? Best thing since white sliced bread!

Before the new checkboxes arrived I was using wingding symbols

. I can toggle them using VBA and double clicking on them. Once you set them up. their easy to maintain. The only problem is that they don't display true or false, but rather ¨ and þ.

 

[bickersc]

I appreciate the help, but I ended up going a different route.