Box Number Of Number Vba Help Follow
I've just been asked to try and figure out some VB code to accomplish the following;
I essentially want to create a field that looks at a quantity, and then increments a number based on the number of copies of that label.
So basically we'll have 1 of 2, 2 of 2, 1 of 3, 2 of 3, 3 of 3, etc, etc
We have a workaround that involves selecting only certain lines of the data to print, and doing this for each individual line, as the first number (i.e the "1 of" number) just continually increases based on the number of copies, so regardless of the second number, it will keep increasing (i.e 1 of 2, 2 of 2, 3 of 3, 4 of 3, 5 of 3, etc).
I imagine the code will look something like this;
FirstNumber.Value = 1
For Each Copy
FirstNumber.Value = FirstNumber.Value + 1
FirstNumber = SecondNumber
Goto Next Copy and repeat event
Has anyone got any ideas?
Michael Toupin (mtoupin
Please sign in to leave a comment.