Adding & Subtracting Using Checkboxes

bickersc

New Member
Joined
Aug 7, 2024
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
1727980951556.png
. 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 þ.
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top