Is there a way to create a macro so when you select the cell and click an "add" button (for example) the number of the cell will increase by 1.
I am looking to do this with an subtract button too but want to make it so the number can not go below zero also
Any help or guidance would be greatly appreciated, thanks
In its most simplist form. This is extremely basic but if you always select the cell you want to increase the value of, as you mentioned, prior to clicking a button with this macro assigned to it, it should work just fine. If you are going to be increasing the value in the same range all the time I would get away from "Selection" and specify the range.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by stnkynts; 10-04-2012 at 12:01 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks