Is there a way of creating a manual counter. For example if cell A1 was made into a "up" button and Cell B1 started at 0 and cell C1 was made into a "down" button. Then if A1 was clicked the number in B1 would increase and vise versa for C1.
Thanks
Ivan
Last edited by VBA Noob; 07-12-2008 at 02:43 AM.
You can add in a "Spinner" from the Form Controls toolbox that should do the trick. After you have inserted it in the sheet right click on it and go to the "Format Control" option and set the Cell Link as $B$1. Then when you click on the up or down arrows the cell will increase or decrease by 1 (or whatever you set the incremental change to. The max in this control is 30000, but that is quite an increase if you are doing it manually so hopefully it will suffice.
Hope that helps.
Claymation
That's great thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks