Random clipart into cells via userform

Watchdawg

Board Regular
Joined
Jan 21, 2015
Messages
65
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?
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,127,859
Messages
5,627,294
Members
416,237
Latest member
Tethys

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top