Thanks very much for making this video -- the very thorough explanation was very helpful in helping me to figure out a task related to what was covered in the video.

Exactly what I needed and clearly explained. thanks!

Thank you. Much better than others because you explain it all.

Thanks a lot sir, very clear and explained so good!

Great job Dinesh, very very useful!

Thank you sir for the video. You made it very clear!

Wonderful video! thanks a lot for your video Dinesh!

Hi Dinesh, this was very helpful. I just would like to know how can display multiple photos in one worksheet. Instead of displaying one at a time, I would like to display multiple a a time. Thanks

Thank you so much, I refreshed my memory on doing photo display using vba, and your videos have a lot of clarity too, God bless

Hi, great video! Thank you so much.. this is exactly what I am looking for! But one question: What do I need to add in to the script if I want to fix a range for the picture to be inserted? Please guide me where to add the script and what to write. :) Thank you

Only one word for u sir *Genius*

@Dinesh Kumar Takyar Dear Mr. Takyar, thanks a lot for your explenation. I have small issue, that when I run the program I had error says: variable not defined myDir. Does the function myDir works on Excel 2013?? Best regards

Thanks Dinesh, this is useful.

Thanks for the video. Very useful.

Hello your video is very helpful thank you so much :) but I have a little question, I did everything in the video excep the "on the error go to" because the photos that are displayed in my document are directly the ones that I want to display so there is no error, but I would like a button or the photo to be a button to erase the photo after is displayed or something like a message box that opens with the photo and then after you see the photo click on the message box to erase it, or something, I would appreciate your help so much !! thank you !!

Really Appreciated for your VBA Code,but is there is any macros coding to create a bulk images link of pictures in excel via dropbox or googel drive or any other images source link to saves time

Thanks Dinesh - Very Helpful Video !!!

Very useful video. Thanks sir

Dear Mr. Takyar, this is a great tip to display the image in Excel sheet, thanks a lot. How can I handle this situation, where I would like to display an image stored in a different folder by clicking a series of cells containing the images' file names each time. Also how can I avoid the collapse while compressing the folder and sending it to a different email address. thanks

thank you very much sir..

Thank You Sir !

Sir, it really amazing for me but sir i wish to know that how to feed data in second and third rows and so on kindly help.

Hi Dinesh, its a amazing video, i am trying to insert more than 1 image in 1 sheet by creating another button. So i have button 1 using your macro, then i have created another button on the same page using a similar macro but with relevant cells. Now when i run the second macro my first image which i got from 1st macro gets deleted. Is it possible to have 2 different macros give me 2 images.Please note i want the same function which you have used above, ie everytime i punch in a sku number it deletes the previous image and replaces with new one.

Excellent video. Thank you very much Dinesh for your well prepared tutorial. What if the pictures have different file extension: jpeg, jpg, jpe, jxr, png, tiff, tif, bmp? how do you code it? thanks a lot in advance

Hi thanks for the video, I want to add many pictures (1000+) linking a part number starting in cell A2 to A1000. in Column C i want to add a photograph that corresponds to each part number. How do I do it?

Thanks Somuch

Hello Sir, Thanks for the information. with the code you provided I am just getting the name of the image and not the actual image in the cell Can you please help.

thank you sir, i have used this code in excel, it work very well at first but when i reopen this excel file the older photo never delete it just overlap plz give solution

Very useful thank

thanks & Great

excellent....

Thanks Dinesh for the video, When i protect the sheet, the picture won't delete because it's locked, help me to unlock the picture before display it, thanks.

excellent

Hello Sir, hope you are doing well, Sir kindly let me know to add search button command on advance user form please reply.

Sir please upload a video on how to insert picture in to outlook mail body using Excel VBA.

مرسی

I would like to do the same thing but change to display 20 of product name lists and match with 20 of product pictures in 1 page a4 for customer. Do I have to change something in VBA?

I was wondering if , when you update this film?... That you can make an "employee" class, and include the picture as a property, and create another version of this code.. I am trying to do it now, and failing ..lol because my knowledge of classes is elementary.please help! it would be nice to get 2 wonderful lessons at once.

Thankyou so much sir your video is really helpfull

Sir how to make image search box in excel userform

I use .png and .jpg as I add to PNG?

when i change position of image in code it leaves a copy of old position in place. I don't want it to do that. I am not sure how to get rid of the old image. To be exact, I used your video to help me make a coin flipping program that uses a randbetween(1,2) and an if statement to supply the string text either "heads" or "tails" in the "A2" box. And it all worked out fine. I am able to click the button I called "Flip the Coin" and it generates either side of photo image of a coin (in this case a quarter). BUT when I go back to the code and try to change where the image will appear, it does change the location of active image but it also leaves the old image in place and I have tried to delete it to no avail.

Sir Myexcel sheet has two pic in two different cells After uploading first pic when I load second pic it delete first pic itself.. (Activesheet.pictures.delete) But I want to keep both pic And delete them on next lookup... Please Advise thankyou

Hi Dinesh! I am receiving the error "specified file not found" however the path (Directory) is the correct one. What could it be?

I have a dashboard with X number of options each and every single one of them has a commandbutton asigned and i would like to display a picture after clicking on any of them...¿thoughts?

Very useful for my database but I have a question is there posible to insert multiple pictures in a single place based on a primar value ( wich has sub values - ex: Mike , Mike 1, Mike 2 etc) and being able to change them by back / forward buttons ?

Sir how can i give range for B2 to B11. For example in B2 i mentioned Pritam so pritam image should come like that in B3 Das so das image should come. Everytime its throwing error in this line "ItemCode = Range("B2")".

Hai Sir. Thank you very much for posting the videos. I have a one question how to insert a crop picture using macro.

Hi. This is what I was looking for. Very good explanation on how to add pictures using VBA, but I am having an issue with the following two lines: myDir = “C:\Users\” MsgBox “File does not exist.” & vbCrLf & “Check the name of the employee!” It appears the message box: Compile error: Symtax error . Could you help me to solve this? I am using Excel 2016. Best regards, João Rodrigues.

Hey thanks for the video. Just have one question....What if we want to automaticly resize the cell( both row and column) where the picture is?

i exactly created the same , but it is not working... can you help... Error : ActiveSheet.Shapes.AddPicture Filename:=myDir & EmployeeName & T, Linktofile:=msoFalse, savewithdocument:=msoTrue, Left:=190, Top:=10, Width:=120, Height:=120

nice video, but can you please make automatic picture display without command button

dear sir, how we can insert picture from userform vba to excel sheet in next empty cell can you help sir,

any body can help ? very first picture not being removed. after first picture this method working fine. except very first picture. thanks

script function ok but old image not remove.

Gud Mrng Sir, Please explain below question how to open excel with image ? Example : when am click on the image the open excel workbook

How can I display an image in Windows Viewer.., that is, independently of Excel..thank you ..thank you🙏💐

Dear Sir, thanks for ur videos its helping me alot in my career . my question is how can u link a pdf file same way its showing the pictures? thanks in advance.

Does this work also when pulling images from a Mac file? Or do I gotta make some modifications?

Can someone please help me, your video sir is illuminating but i have a similar problem: I have built a quite big macro, devided in four subs. I run all of the subs simultaneously by calling them with a main sub at the top. I need for EACH of those subs to give a command that depends on the values of three cell. Ex: First sub If range("B16")=0 and range("B22")>0 Then Picture '-------------------picture file at cell L10 Second Sub: If range("B16")>0 and range("B22")>) and range("E36")=0 Then picture And so on. Can someone help me?

It appears the message box: Compile error: Syntax error . Could you help me to solve this? I am using Excel 2007.

Hi Dinesh, Your video is very clear but unfortunately I can't seem to be able to debug correctly.. can I contact you in any way for some help? Thank you in advance, Olimpia

Dear Dinesh, thanks a lot for your instruction. can you send me this file? thanks

Dear sir, is there a way to insert an online image to excel with VBA?? thank you in advance

if i send it via email lotus notes the receiver gets msg linked image cannot be displayed, file may have been removed, renamed or deleted. Any solution for this?

Kindly Send Me Work Book With VBA Code.I need for this Work.Thanks

Instead of activesheet what we can mention in macro For me is not working Can you help plz

How to pick up the Jpeg & Jpg format on single format

Respected Sir, Thanks for sharing this video. But, if i have to add the picture or image in Comments. Then how to proceed for that. Could you please tell us. Thanks in advance!!

this is really good thing to save time. But when I tried it I got a dialogue box of RUN TIME ERROR " Unable to get the insert property of the picture class" but when I changed my pictures name from IMG_20200815_085825 to any word name such as jai it will work. Can you help me to work this without changing my pictures name??

Is it possible to display address, contact number and picture at the same time????

I want to show multiple images in multiple row.based on their cell value... I am working on a flag project and want the macro like that when the user type the country name in cell hence in the next cell that corresponding country flag should display. and i need that at one time if i put 10 country names in 10 cells and click on display button so flag should generate on that basis. also looking for one button which clear things from both cell (country name and flag). could you please help me to create such type of macro....

Can you tell me how will I get image by link

Dear Sir , Hope you are doing well. I want to ask that how can 24 Hours Time format can be subtracted for time difference calculation in excel vba. I am an Engineering Employee, So that i could calculate machine downtime using 24 Hours format in excel vba. I need your help to do so. Thank You.

sir c:\users\public\pictures\sample pictures\ ye path work nahi kar raha

Plz help me

Good Day,I have tried your code but I am getting error "424 Object required". Can you please help me.Thanks Suresh

Hi Sir, how to convert the selected range into image?

I create commend button and click on it two times then vba project page open but after some second processing vba project close and excel sheet blank. Not Responding show kr rha h. how solve it on MS-Office 2013? Plz solve this issue sir.

How to display more than 1 data and photos in 1 sheet Sir

After inserting the picture, I changed my folder name then it shows me, " the linked picture can't be displayed. this file may have been removed. I want to know that after inserting picture, I deleted the picture or folder. Please help me.

Dim assetphoto As String, T As String myDir = "C:\Users\User\Pictures\assets" Assetsname = Range("D8") T = ".jpg" Range("J26").Value = Assetserialnumber ActiveSheet.Shapes.AddPicture Filename:=myDir & Assetsname & T, linktofile:=msoFalse, savewithdocument:=msoTrue, Left:=150, Top:=10, Width:=150, Height:=150 Application.ScreenUpdating = True End Sub cant display pictures Keeps on showing runtime error 1004....please suggest what to do...i have presentation in next 2 days.. FYI my photos are taken by smartphone and are 1280*720 size...please help what is wrong.

Zoom the work area so that mobile users could have best view. Otherwise not benifitable or waste

i would like to use this method but i would like to have the picture inserted in a comment that will pop up when i mouse over the name in row A

sir..can u please post the code here...thnks..

problem debug....i can't solve debug

Sir You deleted old picture first and then you add the new picture..But I want to add New picture first and then delete the last old picture..can you help me out of this problem..

DONT RUN LIKE A TRAIN MATE, CANT SEE