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.
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 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
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
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
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.
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
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
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.
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 !!
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.
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.
Dear sir I have a user form in excel 2010 where i have a textbox and a command button what i want is when i put a name of file it automatically search for pdf file and when i click on button it show me the pdf file in image control or acropdf control on the form. Hiw can i make it work?
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 ?
@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
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?
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.
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")".
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.
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?
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
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
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?
+Kristen Park Should be possible if you have the complete path to the image and the server doesn't require a login. In the latter case you may need a user-name and password to login.
Here's the link to the sample file: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/ It's a good idea to read the description accompanying the video!
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!!
Dinesh Kumar Takyar Respected Sir, Thanks for your response. And Apologies for my late response. Thanks a lot for sharing the video, that has helped me a lot. I have 1 problem. When i automate the process of adding the image in Comments then i cant expand the image. Whereas When i do manually then i can expand and can see the image. That's the only thing is not happening for me when i automate this process. It would be great help if you could you please guide me in this issue also. Thanks in advance Regards, Anand Saboo
sabsravs Respected Sir, I have got the resolution for the above problem. I have 1 question, I can add the picture or image in the respective cell but as soon as i save the excel then the image is getting blurred. Can we avoid this thing by any method. Thanks in advance!!
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.
This link with downloadable sample file will help: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/ Or do a search at www.exceltrainingvideos.com
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?
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??
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?
I found a very simple and convenient solution for those that have not yet mastered advanced commands.I am rolling again! If anyone is interested message me.
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
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.
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....
I have gone through with above link... that good video ... i have seen this previously..... .... I want something should like e.g. if i copy paste the 10 names in 10 different cell so all 10 photos should display..
Also how to keep image size evenly so its not look stretched. Currently the images are not coming in proper size which i cant use in business presentation.
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.
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.
Check your code line by line. Refer to www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/ Or search www.exceltrainingvideos.com
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..
You can run the 'delete' part of the code first. This link will help: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
Use an IF condition with 'AND'. You can find the concept here: www.exceltrainingvideos.com/copy-data-to-another-excel-workbook-based-on-criteria-using-vba/
Use a looping process. This link will guide: www.exceltrainingvideos.com/for-next-loop/ You can also search my channel or above website to understand 'loops' in VBA.
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
Wonderful! Please share my RUclips channel on Excel with your friends.
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.
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 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. Much better than others because you explain it all.
Craig Clark Thank you!
Exactly what I needed and clearly explained. thanks!
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
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
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.
Hai Sir.
Thank you very much for posting the videos.
I have a one question how to insert a crop picture using macro.
Have you tried to insert a picture by changing its height and width proportionately?
Great job Dinesh, very very useful!
Wonderful video! thanks a lot for your video Dinesh!
Thanks Dinesh - Very Helpful Video !!!
Glad that you found the video helpful.
Only one word for u sir *Genius*
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 for the video. Very useful.
Thank you sir for the video. You made it very clear!
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.
Thankyou so much sir your video is really helpfull
Please share with your friends also.
@@Exceltrainingvideos sir, i ave face some problem, when i have change path from other drive , then VBA not working , kindly guide.
Thanks :)
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
Thanks a lot sir, very clear and explained so good!
Very useful video. Thanks sir
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.
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 !!
Sir please upload a video on how to insert picture in to outlook mail body using Excel VBA.
Thanks Dinesh, this is useful.
Thank You Sir !
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.
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.
+Waqas Ahmed Give an example because the question is not quite clear.
Dear sir
I have a user form in excel 2010 where i have a textbox and a command button what i want is when i put a name of file it automatically search for pdf file and when i click on button it show me the pdf file in image control or acropdf control on the form.
Hiw can i make it work?
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 ?
Yes, that is possible.
How can I display an image in Windows Viewer.., that is, independently of Excel..thank you ..thank you🙏💐
@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
Gud Mrng Sir,
Please explain below question
how to open excel with image ?
Example : when am click on the image the open excel workbook
Insert a picture or image and use a hyperlink to the appropriate workbook.
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?
Did you notice that the picture doesn't really reside in a cell?
What if the pictures resides in a cell? How do we resize cell to fit image?
The same question, is there a solution?
nice video, but can you please make automatic picture display without command button
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.
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?
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.
Try another folder like C:\Users
odri
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")".
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.
dear sir, how we can insert picture from userform vba to excel sheet in next empty cell can you help sir,
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?
Hi Dinesh! I am receiving the error "specified file not found" however the path (Directory) is the correct one. What could it be?
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
email: takyardinesh@gmail.com
Very useful thank
Hello Sir, hope you are doing well, Sir kindly let me know to add search button command on advance user form please reply.
Does this work also when pulling images from a Mac file? Or do I gotta make some modifications?
This link will help: www.rondebruin.nl/mac/section5.htm
thank you very much sir..
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
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?
thanks & Great
Dear sir, is there a way to insert an online image to excel with VBA?? thank you in advance
+Kristen Park Should be possible if you have the complete path to the image and the server doesn't require a login. In the latter case you may need a user-name and password to login.
excellent....
Dear Dinesh, thanks a lot for your instruction. can you send me this file? thanks
Here's the link to the sample file: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
It's a good idea to read the description accompanying the video!
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!!
sabsravs Have a look at this web-link: www.exceltrainingvideos.com/how-to-automate-display-of-pictures-using-comments-with-vba/
Dinesh Kumar Takyar
Respected Sir,
Thanks for your response. And Apologies for my late response.
Thanks a lot for sharing the video, that has helped me a lot. I have 1 problem. When i automate the process of adding the image in Comments then i cant expand the image. Whereas When i do manually then i can expand and can see the image. That's the only thing is not happening for me when i automate this process.
It would be great help if you could you please guide me in this issue also.
Thanks in advance
Regards,
Anand Saboo
sabsravs
Respected Sir,
I have got the resolution for the above problem.
I have 1 question, I can add the picture or image in the respective cell but as soon as i save the excel then the image is getting blurred. Can we avoid this thing by any method.
Thanks in advance!!
any body can help ? very first picture not being removed. after first picture this method working fine. except very first picture. thanks
excellent
Kindly Send Me Work Book With VBA Code.I need for this Work.Thanks
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.
+Imran Anwar Record a macro step by step.
+Dinesh Kumar Takyar Dear Sir,With due respect which macro to record for this time calculation.
+Imran Anwar This video might help: ruclips.net/video/CD_OjJeKbhk/видео.html
Good Day,I have tried your code but I am getting error "424 Object required". Can you please help me.Thanks Suresh
This link with downloadable sample file will help: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
Or do a search at www.exceltrainingvideos.com
I use .png and .jpg
as I add to PNG?
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?
The path to image file is important. It should be accessible to the receiver.
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??
Check your code line by line.
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?
I found a very simple and convenient solution for those that have not yet mastered advanced commands.I am rolling again! If anyone is interested message me.
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
Hi Sir, how to convert the selected range into image?
There's an option to take an image. You can record a macro.
My images are not deleting , even i follow your vb codes exactly
@@ravimandala26mandala73 Record a macro while deleting.
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.
The message is self explanatory.
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....
Check out this link with a downloadable sample file; www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
You should use your paths to the relevant files!
I have gone through with above link... that good video ... i have seen this previously..... .... I want something should like e.g. if i copy paste the 10 names in 10 different cell so all 10 photos should display..
Also how to keep image size evenly so its not look stretched. Currently the images are not coming in proper size which i cant use in business presentation.
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.
myDir = "C:\Users\User\Pictures\assets\" Missing final backspace
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.
Check your code line by line. Refer to www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
Or search www.exceltrainingvideos.com
Thanks Somuch
script function ok but
old image not remove.
It appears the message box: Compile error: Syntax error . Could you help me to solve this? I am using Excel 2007.
Check your code. You can also share your code here in the comments section for further advice.
Sir how to make image search box in excel userform
Instead of activesheet what we can mention in macro
For me is not working
Can you help plz
Use the name of your worksheet.
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..
You can run the 'delete' part of the code first. This link will help: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
مرسی
How to pick up the Jpeg & Jpg format on single format
Use an IF condition with 'AND'. You can find the concept here: www.exceltrainingvideos.com/copy-data-to-another-excel-workbook-based-on-criteria-using-vba/
Can you tell me how will I get image by link
This link will guide: ruclips.net/video/2JoKforqvfg/видео.html
You can also sarch this channel.
How to display more than 1 data and photos in 1 sheet Sir
Use a looping process. This link will guide: www.exceltrainingvideos.com/for-next-loop/
You can also search my channel or above website to understand 'loops' in VBA.
Zoom the work area so that mobile users could have best view. Otherwise not benifitable or waste
sir c:\users\public\pictures\sample pictures\ ye path work nahi kar raha
sir..can u please post the code here...thnks..
+Julius Laurella www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
This link is also available in the 'description'.
Sir..I tried the code but i has error says Error 438 objects doesnt support this property or method..please help..
Is it possible to display address, contact number and picture at the same time????
Search www.exceltrainingvideos.com
Yes, you can use Vlookup formula
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
Try this link: www.exceltrainingvideos.com/tag/automate-display-pictures-comment-box-vba/
problem debug....i can't solve debug
Plz help me
DONT RUN LIKE A TRAIN MATE,
CANT SEE