I have a list of accounts that I want to reduce by a %. I use spin buttons to reduce the account and reflect the saving. I want to be able to click a check box to reset all the spin buttons to zero. I have attached a test file.
Thanks in advance
I have a list of accounts that I want to reduce by a %. I use spin buttons to reduce the account and reflect the saving. I want to be able to click a check box to reset all the spin buttons to zero. I have attached a test file.
Thanks in advance
Last edited by Aland2929; 12-06-2011 at 05:58 AM.
hi Aland2929, it can be done this way around. Range G3:G5 has been moved under the spin buttons block. Try to click the checkbox. Until the checkbox is checked you will not be able to set any %. This approach uses no VB
Thank you watersev. That gets the job done. Thanks for your time and effort.
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks