Excel VBA Secrets: Master Pictures Tutorial + FREE Cheat Sheet

Рет қаралды 6,006

Күн бұрын

🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDV...
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIT...
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/Men...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Pat...
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/Exc...
📣START LEARNING VBA HERE ► rebrand.ly/VBA...
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/Fre...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTM...
Pictures are a big part of creating applications in Excel. In this tutorial, I will take you step by step on how to add, size, position and work with any picture in VBA. I will be writing the code for you in a simple, step-by-step and easy to follow instructions. Make sure to download the Picture In Excel Cheat Sheet & Codebook as well.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/WorkngW...
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/Fre...
►MENTORSHIP PROGRAM: rebrand.ly/Men...
►DASHBOARD MASTERCLASS: rebrand.ly/Exc...
►BEGINNERS VBA COURSE: rebrand.ly/VBA...
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/Web...
EXCEL PRODUCTS:
►Get 500 Done-For-You Macros: rebrand.ly/UDV...
►Get 350 Templates In 1 Zip File: rebrand.ly/350...
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIT...
►The Ultimate Excel Resource Guide: rebrand.ly/UER...
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC...
►1000 Incredible Freelancing Resources: rebrand.ly/UFR...
🧐Find the Best Excel Products & Courses Here: rebrand.ly/Exc...
Timestamps:
0:00 - Introduction
1:19 - Overview
3:49 - Browse For Picture
9:31 - Insert Picture
22:46 - Open Picture
26:17 - Picture In Shape
JOIN OUR COMMUNITY: rebrand.ly/EFF...
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦X: x.com/Excel4Fr...
🌏Website: www.ExcelForFr...
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/E...
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelVBA #PicturesInVBA #ExcelPictures #InsertPictureInExcel

Пікірлер: 37

@ExcelForFreelancers 3 ай бұрын

🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

@gaspumprepairservice7009 3 ай бұрын

Ohhhh, I am liking this, Randy. You have an awesome talent of making complex ideas simple for folks like me. Thank you!

@ExcelForFreelancers 3 ай бұрын

Thank you so very much, I really appreciate that and I am happy to help and share

@joemanflyer2001 Ай бұрын

This is what makes using Excel fun! How in the cool pics !

@ExcelForFreelancers Ай бұрын

Great thanks so much. I am glad you enjoy it.

@markhuang368 3 ай бұрын

Thank you, Randy.

@ExcelForFreelancers 3 ай бұрын

For sure, you are very welcome Mark and I am happy to help and share

@sohealsingh 3 ай бұрын

Marvellous Randy, very very useful

@ExcelForFreelancers 3 ай бұрын

Thank you so very much, I really appreciate that and so glad you enjoyed it

@lpmgenius65 3 ай бұрын

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 :)

@ExcelForFreelancers 3 ай бұрын

That is really so great to hear. I am so happy to help and share. Much appreciated

@henkvinck888 3 ай бұрын

Beautiful,Thank you so much Randy

@ExcelForFreelancers 3 ай бұрын

Thank you so very much, I really appreciate that and I am happy to help and share

@SyedMuzammilMahasanShahi 3 ай бұрын

Thank you so much Randy for this amazing video.

@ExcelForFreelancers 3 ай бұрын

For sure, you are very welcome Syed. I am happy to help and share as always

@michaeltedford2177 3 ай бұрын

Well done Randy. Thank you.

@ExcelForFreelancers 3 ай бұрын

Thank you so very much, I really appreciate that Michael

@dateseater5306 3 ай бұрын

As usual, an awesome tutorial. Thank you Mr. Randy. You are doing a selfless service.. Kudos to you.

@ExcelForFreelancers 3 ай бұрын

For sure, you are very welcome and I am very happy to help and share. Much appreciated

@Romariowll 3 ай бұрын

beautiful

@ExcelForFreelancers 3 ай бұрын

Thank you so very much, I really appreciate that

@peterjames8046 3 ай бұрын

In the sub InsertPicture - how can i add multiple shapes to the one sheet

@ExcelForFreelancers 3 ай бұрын

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.

@ncalc2261 2 ай бұрын

Hi Randy, please update your microphone. The sound is kind of muffled

@ExcelForFreelancers 2 ай бұрын

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.

@ochakpormavis4198 2 ай бұрын

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?

@ExcelForFreelancers 2 ай бұрын

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.

@temyraverdana6421 3 ай бұрын

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

@ExcelForFreelancers 3 ай бұрын

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: kzfaq.info/get/bejne/nM1gm7Omsaq9p4U.html Thanks again for your continued support

@temyraverdana6421 3 ай бұрын

@@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

@ExcelForFreelancers 3 ай бұрын

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 kzfaq.info/get/bejne/Z9mKl6uUzd_NkqM.html I hope this helps and thanks so much.

@kabelhossen8584 3 ай бұрын

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.

@ExcelForFreelancers 3 ай бұрын

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.

@pablozambrano7235 3 ай бұрын

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 ....

@ExcelForFreelancers 3 ай бұрын

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.

@kiedraana5625 3 ай бұрын

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

@ExcelForFreelancers 3 ай бұрын

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: kzfaq.info/get/bejne/jcCIeZmpq6rMdnk.html I hope this helps and thanks so much.