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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Adding & Subtracting Using Checkboxes
- Thread starter bickersc
- Start date
Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 3,152
- Office Version
- 365
- Platform
- Windows
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 þ.
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
Upvote
0
