Picture selected from drop down list, displayed on two worksheets at the same time.

[JonesyCC]

Hi I have the below piece of VBA code which works very well. What it does it calls a image from a worksheet called "Pictures" based on a selection make from a drop down list in cell A9 on worksheet "Sale Order Form". It does all of that perfectly, but I need to change the code so the image is display on both the "Sales Order Form" worksheet like it does now, and on another worksheet called "Customer Sales Order Form" in the same position.

To sum up I don't want to change what this code is doing right now, all I want is to add on to this code to have it display the image both on the current sheet and a second sheet called "Customer Sales Order Form".


Is there anyone out there that can please help me.

Thanks in advance Dave

Example Workbook

example spreadsheet.xlsm

The Code

Please Login or Register  to view this content.

[JonesyCC]

Please find the solution to your question below.

Thanks Dave

Please Login or Register  to view this content.