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 :
• Excel VBA UserForm Sea...

[@aravindbiology]

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

[@johng5295]

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

[@ExcelDestination]

Very welcome!

[@MohAboAbdo]

Thank you very much for this great video.

[@scouter-xn6zi]

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.

[@javedahmed8343]

Simple and concise

[@ExcelDestination]

thanks

[@javedahmed8343]

Very nice, cool explanation

[@ExcelDestination]

Thank you!

[@javedahmed8343]

Fantastic explanation

[@ExcelDestination]

thanks

[@mxrvxn08]

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

[@veebee3969]

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

[@alamzicury8496]

Thank you.

[@bluejay12293]

mine is in PNG format but it says invalid picture

[@harrisuryana994]

Tq easy to understand

[@ExcelDestination]

Welcome 😊

[@annaduenas7994]

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.

[@sridharkrishnappanavanerth3388]

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

[@musagorgun6684]

teşekkür ederim

[@renzsantillan5815]

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

[@mlungisisigasa8255]

Thanks

[@mostaphabouta6787]

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

[@ExcelDestination]

Thank you!

[@PvodHuo]

Thank you sir.

[@aguyy222]

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!

[@ExcelDestination]

not sure, however I would suggest that each active x control has a unique identity. So, try to use that.

[@nagendraprathap9697]

Thanks Sir 👍

[@dree543]

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)

[@ExcelDestination]

yes, It would be.

[@dree543]

Alright, thank you for the clarification, I'm going to do it and will let update you..thanks again 🙂

[@ImranKhan-pk1ol]

How we save picture in ms excel sheet in this usreform

[@priyakantsoni2362]

Sir u know about vba coding for coreldraw?

[@priyakantsoni2362]

I want learn coreldraw vba programming

[@aset012585]

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

[@ExcelDestination]

Not yet

[@aset012585]

@@ExcelDestination hope you make tutorial for that as well. Thank you! new susbcriber here.

[@shalinigupta1419]

thanks

[@priyakantsoni2362]

Can u help me?

[@Seth6000]

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

[@ExcelDestination]

check this : kzbin.info/www/bejne/a37Hi4KrbruEnbs

[@_adi_dev_]

@@ExcelDestination not the answer

[@jayecavallo8759]

Hi. Thank you for this video. Is it possible to use VBA in Excel to embed an image on an Userform so that the Excel file can be shared to other users?

[@ExcelDestination]

yes it is possible. you need to search for excel file as active x control.

[@jayecavallo8759]

@@ExcelDestination Ok, that might be a bit advanced for me. I am trying to display an embedded image on a userform based on the choice of a combo box.

[@ehabmohammed9196]

​@@jayecavallo8759 could you get the answer if you get it let me see plz

[@callumwyper]

@@jayecavallo8759 Hi, did you manage this ? ive been trying for a couple of days now in amongst other things and i cant seem to manage. Also is there a way of improving combo box so that you can typer any part of the listed options and it still show up? i have managed to do this but it then wont let me select the answer and just leaves the combobox blank thank you for your help!

[@emre318]

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.

[@ExcelDestination]

yes, it is possible

[@emre318]

@@ExcelDestination it didn't work man. When I put variant path name in loadimage code it gives error. For ex column A in sheet1 is name of products and column b is url of their pictures. By selection change, I reflect the url to Z1 cell when you click on product name and then double click the Image1 and define imglnk to sheet1 z1 cell so each time I click on a product name imglnk changes. Then I write the code as you did on the video: Image1.picture=loadimage(imglnk) but it doesn't work.

[@ehabmohammed9196]

@@emre318 ​ could you get the answer if you get it let me see plz

[@neels1506]

Nice

[@ExcelDestination]

Thanks 😊

[@neels1506]

@@ExcelDestination i have one doubt. Can you clarify. Please share your mail id

[@Niska099]

Thanks for the video :) can you please also create a video of - how to insert a picture in Excel form using image available in the same excel workbook (not from the local desktop). in this way, if I send the excel file to someone, it will still be able to refer the embedded image in the Userform.

[@ExcelDestination]

I would suggest, for that you can use Excel Outlook automation using VBA code and insert image. Not sure, if it helps. let me know pls.

[@farhanislam3707]

Image should go From userform to excel sheet In front of name

[@ExcelDestination]

that can be done from different code

[@farhanislam3707]

@@ExcelDestination Sir i asked about this code.but u said in next video. I was happy to see your video. But at the end my problem is still there. Hopefully in your next video. I will find my answer. May u live long and your channel Thanks and regards

[@awadhbinamro948]

thank you for this tutorial, could you plz send me this work file

[@ExcelDestination]

email ?

[@princemudasirprincemudasir7390]

00