I am using the below macro to either add to a number or subtract.
The parameters are based on affecting an adjacent cell.
It is easy to use as it does not require doing repetitive macros like a command button would need.
Is it possible to use a generic code for a toggle switch, like the below macro, thus making my sheet smaller and more user friendly.
Here is a copy of the book.
Please Login or Register to view this content.
Hello TBM,
The Workbook you have uploaded has Sheet1 Protected with a Password. Please remove that Password for the ease of use for fellow Forum Members, or provide us with the Password.
In the meantime you may use your Code as below:
Please Login or Register to view this content.
Regards.
Last edited by Winon; 03-15-2018 at 11:24 AM. Reason: Spelling
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Attached is a Book with the protection off
I am using the below macro to either add to a number or subtract.
The parameters are based on affecting an adjacent cell.
It is easy to use as it does not require doing repetitive macros like a command button would need.
Is it possible to use a generic code for a toggle switch, like the below macro, thus making my sheet smaller and more user friendly.
Please Login or Register to view this content.
How about:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi TBM,
Thank you for adding to my Reputation.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
How would I use this in a spin button?
Attached is a Book with the protection off
I am using the below macro to either add to a number or subtract.
The parameters are based on affecting an ADJACENT cell.
It is easy to use as it does not require doing repetitive macros like a command button would need.
Is it possible to use a generic code for a SPIN BUTTON, like the below macro, thus making my sheet smaller and more user friendly.
Please Login or Register to view this content.
Hello TBM,
I believe that the way you have it at the moment is the best option. To incorporate Spin Buttons would require a Button for each and every Cell with a Plus and/or a Minus. That is a number of plus minus 250 Spin Buttons, and Coding for each and every one of them.
Hi TBM,
Thank you for adding to my Reputation. Much appreciated
Kind Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks