Excel VBA Secrets: Master Pictures Tutorial + FREE Cheat Sheet

preview_player
Показать описание


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.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

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

#ExcelVBA #PicturesInVBA #ExcelPictures #InsertPictureInExcel
Рекомендации по теме
Комментарии
Автор

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

gaspumprepairservice
Автор

This was an awesome tutorial, 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 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 :)

lpmgenius
Автор

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

joemanflyer
Автор

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

dateseater
Автор

Thank you so much Randy for this amazing video.

SyedMuzammilMahasanShahi
Автор

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?

ochakpormavis
Автор

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

temyraverdana
Автор

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

peterjames
Автор

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

ncalc
Автор

Using vba how to take a picture and remove background picture like passport picture

vpcmleq
Автор

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.

kabelhossen
Автор

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

pablozambrano
Автор

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

kiedraana