Dfense
01-16-2008, 09:30 PM
I want to create a sheet that will act as a counter for different items and display it visually with a bar. I would also like to be able to add and remove items with control boxes etc. With Andy Pope's help I can create a visual counter that adjusts size to whatever I put in "e11"
The problem i forsee is that I set the variable range size (display bar) to the value of "e11". If I use control boxes etc. to add more items with a different counter value below ("e12") how do I get a new display bar since I won't be able to set the variable without editing the code?
The problem i forsee is that I set the variable range size (display bar) to the value of "e11". If I use control boxes etc. to add more items with a different counter value below ("e12") how do I get a new display bar since I won't be able to set the variable without editing the code?