add sequential numbering

[Watchdawg]

OK, found a partial answer. I'm trying to print pallet placards where there might be 10 pallets in a shipment, so when the command button is clicked, it prints 10 copies of the placard, I can do that with the partial answer I found:

.PrintOut Copies:=Range("A2").Value

TextBox1 allows the user to input the total number of pallets on the shipment (i.e. 3), this populates cell E5 on the placard with "3".
C5 is the tricky one. If Cell E5 is 3, then the first printout needs to have "1" in C5, "2" in the second printout, etc.
This way, the placards read 1 of 3, 2 of 3 and 3 of 3.

There's an identifier in B2 that's just a random Wingding font and a delivery number, those will remain the same throughout the print.
If I can figure it out, I'll attach a sample.

[torachan]

see big yellow banner at the head of page

[Watchdawg]

Well, when in doubt look for the obvious....hopefully that worked....

[torachan]

Please Login or Register  to view this content.

[Watchdawg]

That was fantastic! Thank you so much. Perhaps you can assist with one more issue? In order to create a unique identifier for the pallet placards, I need the form to pick a random cell from a range (sheet2, cells A1-A63), place that in B2 on sheet 1. That cell is formatted as Wingding, so it displays a picture which is easier to pair up with other placards from the same sequence. The problem I'm having is that it prints a different random cell on each of the placard sheets (i.e. 1 of 2 has a picture of scissors, 2 of 2 has a diamond). How do I get it to pick something to place there and not change that selection until the total number of pallets changes in the userform?

[torachan]

Remove formula from cell B2 Sheet1 and paste in new code to CommandButton1 on UserForm

Please Login or Register  to view this content.

[Watchdawg]

Saved again, and got a brief lesson in Int / Rnd while I was at it!
Thanks again Torachan