Dynamic picture to a form?

[Jaymond Flurrie]

Any ideas how I could overwrite a picture file with another picture so that my VBA form would after that show the new picture? It doesn't need to happen on the fly, the idea is that my customer doesn't know what picture there should be and I'd like to say "ok, once you decide, just overwrite this one here with the picture of your choice".

 

[Jerry Sullivan]

This post might help you:

http://www.mrexcel.com/forum/showthread.php?t=516887

That was describing how to change images on the fly. It was referring to an image, but you can adopt the same approach to the Form's Picture property.

The key decision is whether you want to embed the image or link it to a source file. If you do the latter, your easiest solution would be to overwrite the linked image with a different image using the same filename.

 

[Jaymond Flurrie]

This post might help you:

http://www.mrexcel.com/forum/showthread.php?t=516887

That was describing how to change images on the fly. It was referring to an image, but you can adopt the same approach to the Form's Picture property.

The key decision is whether you want to embed the image or link it to a source file. If you do the latter, your easiest solution would be to overwrite the linked image with a different image using the same filename.

Yeah, I just thought to tell my customer that "replace this "logo.jpg" here with your "logo.jpg" and it'll appear on the form", so exactly like you wrote. Thanks for the link!