vba to show different pictures

[steveg666]

Hello all
Is it possible when an operator presses customer1 the user form opens (which works) ‘frmcoursebooking’ they then select from the drop down menu the item required eg item A then on the bottom right a picture is displayed of that item (pictures on ‘pic sheet’) I have tried in vain to make this work so any help would be much appreciated. Thanks in advance

[Tinbendr]

Your project is password protected. Reupload with password removed.

[steveg666]

sorry please try this one

[Tinbendr]

You'd think that referring to a image on a sheet to a userform control would be easy. But it seems the creators of Excel missed that one.

This works, but not without much help from Stephen Bullen's Excel Page - PastePicture.zip.

Stipulations:
Sequence of combobox items much match sequence of pictures. You could make a table (Probably on the picture page) to lookup a dropdown name to picture name. That would certainty be more robust.

Names of pictures must be Picture #. (unless you make fore mentioned table.)

[steveg666]

super star thank you so much 10/10