Good morning, all. I'm attempting to make a placard. The clipart is going to serve as a visual identifier (a 3 pallet shipment will have placard 1 of 3, 2 of 3 and 3 of 3 hopefully, that might be a separate post), all three placards need the same picture to tie them together visually.
Cells are merged From B1:E3, so I need the clipart to take up as much of that space as possible for distance recognition. When the user inputs the data in the userform (total pallets and delivery number) and clicks the control button, it should place the random clipart from a file into the merged cells and populate the other cells for pallets and delivery number, then print 3 placards all containing the initial clipart chosen.
I've seen some solutions that get close, but either nothing is working just right or I'm not doing something right.
can anyone help?
Cells are merged From B1:E3, so I need the clipart to take up as much of that space as possible for distance recognition. When the user inputs the data in the userform (total pallets and delivery number) and clicks the control button, it should place the random clipart from a file into the merged cells and populate the other cells for pallets and delivery number, then print 3 placards all containing the initial clipart chosen.
I've seen some solutions that get close, but either nothing is working just right or I'm not doing something right.
can anyone help?
