Picture in a form, can the source image be changed using VBA?

[proepert]

I have a form with a picture object. I have five different pictures I want to show on the form, based on the value of a cell when the form is initialized.

The five different pictures are located in cells in the same workbook.

Is it possible to use VBA code to change the image being displayed in the picture object on the form?

So far I have all five images on top of each other and then use [Visible = False] or [Visible = True] for each image as required, but maybe there is a better solution to this.

[Andy Pope]

You can use a linked picture for a non vba solution.

http://www.jkp-ads.com/Articles/ShowPicture00.asp

[proepert]

Thank you Andy, you have helped me often. I started with the linked picture solution, but the response is real slow. I have to change the data validation as well as the picture, and the combination is painfully slow even with screen updating toggled off.

I have the form working. I just located each image in the same location on the form and toggle the visibility of them as required. A plus to using the form is the user can hide the form when they don't care to see the pictures.

Thanks again so much for taking the time to reply to this thread.