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.
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)
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!
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.
@@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!
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 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.
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 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
Thank you for this vid. how about if the picture is within the workbook? Thank you
Fantastic explanation
thanks
Very nice, cool explanation
Thank you!
Thanks in a million. Great content. Awesome. Grade: A++
Very welcome!
Thank you very much for this great video.
Excellent narration,easy to follow. Have you developed school manager in excel?
Simple and concise
thanks
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.
Thank you for the video. How do you use an Icon provided by Excel (Insert/Icons) in the image box on a userform?
Tq easy to understand
Welcome 😊
mine is in PNG format but it says invalid picture
Thank you.
Sir u know about vba coding for coreldraw?
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)
yes, It would be.
Alright, thank you for the clarification, I'm going to do it and will let update you..thanks again 🙂
Hi! Do you have tutorial in adding image to pdf file using vba?
Not yet
@@ExcelDestination hope you make tutorial for that as well. Thank you! new susbcriber here.
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!
not sure, however I would suggest that each active x control has a unique identity. So, try to use that.
How we save picture in ms excel sheet in this usreform
Thanks Sir 👍
Thanks
teşekkür ederim
the picture is not following the size of the image control eve if iclicked true on the auto size
Sir i get Run time error -53 'File not found' when i run program. Please help.
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.
Nice
Thanks 😊
@@ExcelDestination i have one doubt. Can you clarify. Please share your mail id
With this great video you have win my suscription to your channel and one great like thanks
Thank you!
Thank you sir.
How do I use Picture that it's in the excel already?
check this :
th-cam.com/video/5MdZOu9VQgY/w-d-xo.html
@@ExcelDestination not the answer
I want learn coreldraw vba programming
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?
yes it is possible. you need to search for excel file as active x control.
@@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.
@@jayecavallo8759 could you get the answer if you get it let me see plz
@@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!
Can u help me?
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.
yes, it is possible
@@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.
@@emre318 could you get the answer if you get it let me see plz
thanks
thank you for this tutorial, could you plz send me this work file
email ?
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.
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.
Image should go From userform to excel sheet
In front of name
that can be done from different code
@@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
00