Insert Picture in Userform using Image Control - Userform with Image in Excel VBA

This Excel VBA Userform example explains how to insert image in userform using image control. We can load image on userform using simple vba code on userform initialize event.

Watch Advanced Userform to Search, Display, Add and Delete at :

[mxrvxn]

Thank you for this vid. how about if the picture is within the workbook? Thank you

[johng]

Thanks in a million. Great content. Awesome. Grade: A++

[veebee]

Thank you for the video. How do you use an Icon provided by Excel (Insert/Icons) in the image box on a userform?

[MohAboAbdo]

Thank you very much for this great video.

[aravindbiology]

Excellent narration, easy to follow. Have you developed school manager in excel?

[bluejay]

mine is in PNG format but it says invalid picture

[scouter-xnzi]

Great tutorial ; to the point and focusing clearly on the exact code you need to load an image. Though silly it may seem, any other tutorial I have watched focuses everywhere else rather than this detail, which is the single most essential to load the picture ... here things are done the simple way 😊

However, I have one thing to ask ; when you "load" the picture (through the initialization of the Userform, e.g. at 7:30), the path is perfect, the picture name is perfect ... but I was betting we would face an "Error" since we didn't write the picture's extension, yet it didn't happen. Why ? I mean isn't the extension a necessary part of any file's (image's) name ? I understand the only result was that the actual image file was not loaded, yet the Userform was landed.

[sridharkrishnappanavanerth]

Sir i get Run time error -53 'File not found' when i run program. Please help.

[dree]

Say i saved this work, and copy it into any thumb drive, open to a different pc/laptop, does the picture still there?? (Since you put -path- option that was in your computer)

[annaduenas]

If someone is having problems with the picture not loading, what I did is I wrote the code at the top of all the other stuff not at the bottom. Idk if it will help.

[aguyy]

I'm trying to use multipage and have different pictures on a couple pages. It seems setting Autosize = True isn't working properly because the image is loading on the entire multipage and not the image box. If I remove the autosize it load in the image box but not properly fitted. Please help!

[SniperScoutXIV]

Hi Sir
Would you mind if i ask, how can i use the picture you have coded to read the directory from folder to be dynamic .. because i want to add my journals and pictures to my Excel sheet ..
it would be very helpful to help with this task. All commands and boxes are suitable with my ideal but i just wanted to be dynamic with the pictures .. ie, it would be better to set button to roll over the picture for next picture ..
Thanks for you help

[renzsantillan]

the picture is not following the size of the image control eve if iclicked true on the auto size

[ImranKhan-pkol]

How we save picture in ms excel sheet in this usreform

[priyakantsoni]

Sir u know about vba coding for coreldraw?

[mostaphabouta]

With this great video you have win my suscription to your channel and one great like thanks

[aset]

Hi! Do you have tutorial in adding image to pdf file using vba?

[Seth]

How do I use Picture that it's in the excel already?

[emre]

Hello, thank you for the tutorial.

Is it possible if we want to run the image from an URL?

Let's say there's a list of names in A2:A5 and url of pictures of them in B2:B5.

What I want is to load picture from the Urls in column b, not the local store.

I do this by selection change and activesheet.pictures.insert code so when you click on the name picture opens in worksheet. But userform can be more facilitative I guess.

[priyakantsoni]

I want learn coreldraw vba programming