This was an awesome tutorial, Randy.....For years, I have tried inserting pictures into my templates, using various methods, vut since I was unfamiliar with VBA, I never used that as an option.....You just made my life so much easier. I now can "finish a lot of programming that was left undone due to the picture insert hurdle. You just saved the day...thanks so much :)
Thank you, Randy. This video is amazing 👏👏 I have a question. If I want to set the picture as the background of my worksheet, how may I tweak the VBA code?
Hi and thanks very much. You can set the page background in the page settings tab. There would be no need to use VBA for this. I hope this helps and thanks so much.
Hi Randy, great useful video. I've a question: there is a function to returntha name of areo of picture I've click or mouse over? I.e. I have a car picture and I would like return the name of the part mouse clic, for example door, windows weel or other clicked. Thanks and see you tomorrow
Hi Temyra, thanks so much for your email. It is possible using an ActiveX component with a Mouse Move event. I go over that in this training: ua-cam.com/video/fg0hPuLDYwQ/v-deo.html Thanks again for your continued support
@@ExcelForFreelancers Thank a lot for hint, very useful. My idea is to develop an interactive catalog, user click on a part of picture and it appears as quantity in store and price. This will be useful to perform cost estimate. How do you think as idea? See you later
HI Temyra, thanks for your idea. I think it is really interesting and could be very useful. Here is another sample in which i use the hover control ua-cam.com/video/1sZdHchyibo/v-deo.html I hope this helps and thanks so much.
Hi and thanks you can simply duplicate the code to add more shapes. You can also add a shape while recording a macro, that will show you how to add specific shapes. I hope this helps and thanks so much.
Hi and thanks for your comment. You would probably want to use a 3rd party API to remove the background. This would require a bit of research however I am sure its possible. Thank you for your Likes, Shares & Comments. It really helps.
Dear, Firstly, I am a humble fan to you. 🇧🇩 I have an Excel File. That have been used 4 years. But suddenly, that file not open. Showing file currupted. Can u help me please.
HI and thanks so much. You can try with a USB scale that has a keyboard interface and also check the manufacturer details on that as i had not worked with one before. I hope this helps and thanks so much.
Hi Randy and All. What a fantastic video, I am struggling with inserting files into Excel. Question how can I insert a pdf, doc, xls or other file. Thks
Hi Keidra, thanks for your email. Concerning inserting files, you would want to insert it as an object. I have a video on that here: ua-cam.com/video/WZXF6xFDhFE/v-deo.html I hope this helps and thanks so much.
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
Ohhhh, I am liking this, Randy. You have an awesome talent of making complex ideas simple for folks like me. Thank you!
Thank you so very much, I really appreciate that and I am happy to help and share
As usual, an awesome tutorial. Thank you Mr. Randy. You are doing a selfless service.. Kudos to you.
For sure, you are very welcome and I am very happy to help and share. Much appreciated
Beautiful,Thank you so much Randy
Thank you so very much, I really appreciate that and I am happy to help and share
This is what makes using Excel fun! How in the cool pics !
Great thanks so much. I am glad you enjoy it.
This was an awesome tutorial, Randy.....For years, I have tried inserting pictures into my templates, using various methods, vut since I was unfamiliar with VBA, I never used that as an option.....You just made my life so much easier. I now can "finish a lot of programming that was left undone due to the picture insert hurdle. You just saved the day...thanks so much :)
That is really so great to hear. I am so happy to help and share. Much appreciated
Well done Randy. Thank you.
Thank you so very much, I really appreciate that Michael
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. I am happy to help and share as always
Thank you, Randy.
For sure, you are very welcome Mark and I am happy to help and share
Marvellous Randy, very very useful
Thank you so very much, I really appreciate that and so glad you enjoyed it
Thank you, Randy.
This video is amazing 👏👏
I have a question. If I want to set the picture as the background of my worksheet, how may I tweak the VBA code?
Hi and thanks very much. You can set the page background in the page settings tab. There would be no need to use VBA for this. I hope this helps and thanks so much.
Hi Randy, great useful video. I've a question: there is a function to returntha name of areo of picture I've click or mouse over? I.e. I have a car picture and I would like return the name of the part mouse clic, for example door, windows weel or other clicked.
Thanks and see you tomorrow
Hi Temyra, thanks so much for your email. It is possible using an ActiveX component with a Mouse Move event. I go over that in this training: ua-cam.com/video/fg0hPuLDYwQ/v-deo.html
Thanks again for your continued support
@@ExcelForFreelancers Thank a lot for hint, very useful. My idea is to develop an interactive catalog, user click on a part of picture and it appears as quantity in store and price. This will be useful to perform cost estimate. How do you think as idea? See you later
HI Temyra, thanks for your idea. I think it is really interesting and could be very useful. Here is another sample in which i use the hover control ua-cam.com/video/1sZdHchyibo/v-deo.html
I hope this helps and thanks so much.
In the sub InsertPicture - how can i add multiple shapes to the one sheet
Hi and thanks you can simply duplicate the code to add more shapes. You can also add a shape while recording a macro, that will show you how to add specific shapes.
I hope this helps and thanks so much.
beautiful
Thank you so very much, I really appreciate that
Hi Randy, please update your microphone. The sound is kind of muffled
Hi and thanks i have since updated some settings on the microphone for a cleaner result. Thank you for your Likes, Shares & Comments. It really helps.
Using vba how to take a picture and remove background picture like passport picture
Hi and thanks for your comment. You would probably want to use a 3rd party API to remove the background. This would require a bit of research however I am sure its possible. Thank you for your Likes, Shares & Comments. It really helps.
Dear,
Firstly, I am a humble fan to you. 🇧🇩
I have an Excel File. That have been used 4 years. But suddenly, that file not open.
Showing file currupted. Can u help me please.
Hi and thanks, you can search for some 3rd party Excel tools that can fix a corrupted Excel file. I hope this helps and thanks so much.
It is possible to read from a Rs232 serial port using vba I am trying to place the values of a digital scale but I have not succeeded so far ....
HI and thanks so much. You can try with a USB scale that has a keyboard interface and also check the manufacturer details on that as i had not worked with one before.
I hope this helps and thanks so much.
Hi Randy and All. What a fantastic video, I am struggling with inserting files into Excel. Question how can I insert a pdf, doc, xls or other file. Thks
Hi Keidra, thanks for your email. Concerning inserting files, you would want to insert it as an object. I have a video on that here:
ua-cam.com/video/WZXF6xFDhFE/v-deo.html
I hope this helps and thanks so much.