Hey, I just wanted to say this video helped me out quite a bit and I really appreciate the time you took on it.

Excellent video! Thank you.

Thank you very much, sir, for this great video. If possible I have a question: How can pictures be renamed as rows?for example copy2, copy3, copy4 etc.... With VBA.

This Video has helped me a lot to make my life simple. Thank a Lot

Thank u so much for Sir i was searching past one month now the problem is resloved...Thank u for this amazing service , God Bless u Sir..Thank u so much again..

Hi Sir, can i get some help. I am not sure if all the images are in the folder, so if any images are not there i would like to have a msg as "Not found" and also an additional command button to clear all the images. Can i get that VBA codes as well which will make my life more easier

Thank you Sir B is in column number from row number 5 to 1,2,3, in the same order there is photo folder in path P also photos are also in number 1,2,3 they want to take in column 35

Hi! This is a great tutorial. But, in my case it did not work! I followed the instructions but when i click the button, a message box was appeared "Object does not support this property method or method". I show the code. The problem is on the line "Set animal_pic = ActiveSheet.Pictures.lnsert(pic_location)". What's ii wrong? What can i do to solve the problem?

Thanks for your great tutorial. I have a request. If I use this with a data validation list and press the command button the refresh the images the previous image are still there underneath the new ones. Is the a command I could use to delete the previous image before placing the new one? Thanks again!

Thank u ver much for the video I need some help though, when i send the file the images dont open, because of the path Is there any way to fix it? Pleeeease

Hello Sir, may get some help? I need to insert hundred of pictures into my product list with respective codes. I have save the pictures with the code in a folder which match with my product list code. However, the pictures are still unable to appear on my product list even I click on > developer > macros > run > import images > select import pictures location from the folder. May I get your help? I can share the product list and pictures files to you. Appreciate for your advice this

Can u help in providing the module for the picture in the user form to be directly transfer in the Excel form also

This video can be help me. Thank you.

Great !, thanks

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 it will work. Can you help me to work this without changing my pictures name??

For a code that works correctly if the direction of the paper is from the left. And it's wrong if the direction of the paper is from the right... How to make the image appear in its correct place if the direction of the paper is from the right

Awesome 👍👍

Excellent Sir.,.

Sir super video , but can't run the program , some error , application & object error sir pls clarify

Hi, Can you help me to unlink the image path of the inserted image by VBA code in excel and save image in the same cell by VBA please. so that I can send the file to others.

VBA the "i" is showing as red(wrong)= i am using B3 as name and picture location as B135. Can you advice

Sir, Could This code work to find picture Folder and into the Sub Folder also

thank you sir, how about deleting the picture?

Can I take a picture I put in the excel and use them in vba forms without loading from somewhere else? I putted a picture in one of the sheets and I want to use that picture in a form is it possible?

Hi how can do Sir plz guide me Where i make change in code

when I click on Insert Picture, It is not taking any action but when I check vba code then it shows error on line no. 6 & showing range error. I am calling cheques as I have needed from folder but 1 thing more if my pictures are in jpeg, jpg, png or other format so how can I call Kindly suggest me on both my queries. Thanks

Really nice. ..

i Have a macro, in Office 2007 working, but in not working in Office 2010,2013,2016 can u help me

what if i want to make the cell ready for any object or image

Merci beaucoup

Thanks sir

I have a request to send with following scenario. If the Name of Animal is a merged cell then how we can insert the picture with the help of VBA.

Sir I have morethan 50 photos so how can change all the name at same time instead of individually one by one please guide me sir

Thanks sir... but i m getting debug here Set stpic = ActiveSheet.Pictures.Insert(piclocation).. i m gett

how to fix the run time error 1004. unable to get the insert property of the picture class.

Bro I am pulling data from nse website option chain I want first highest second highest oi data paste into another sheet how to do that and sheet is refreshing automatically 5 minutes and ever time data come in new row

الكود يعمل بشكل صحيح اذا كان اتجاه الورقة من اليسار ..ويخطا اذا كان اتجاة الورقة من اليمين...كيف يمكن جعل الصورة تظهر في مكانها الصحيح اذا كان اتجاه الورقة من اليمين

I have tried it but after writing the code when I go to Sheet and click over it that returns error of not assigning Function or Sub. Could u pls tell me why I am having this issue/

Unable to get the insert property of the picture class

Thanks

its not working i m getting this error RUN TIME ERROR " Unable to get the insert property of the picture class"

I need same VBA code in note ,

Hi i am get error the "Set animal_pic = ActiveSheet.Pictures.insert(pic_location)" Run-time error "1004": Unable to get the Insert property of the Picture class

insert of picture can we get pdf file

Hi sir If i want to assign pic location address into worksheet cell

could you please send the code

Sir when I clicking insert am getting error message 1004 unable to insert picture class. Pls help how to solve this.

Very helpful... I like your videos.... I have one query that I m working in HR department...I need to send 30 to 40 mails daily using Gmail account ...will you make video for sending emails using Excel VBA via Gmail instead of outlook... Please help me..it will save my time...

Bhi live chat kaha p hoge plz reply

mine presents this error here: it is not possible to obtain the insert property of the pictures class

why not copy code and pin below video ?

Sir. may you share with me the vba code?

This code only adds a single image

not working for 2013

Hello sir answer plz