Learn Excel VBA to Automate Anything

Рет қаралды 349,050

Күн бұрын

Learn Excel VBA essentials in 15 minutes to automate excel tasks.
🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/64679d...
In this video, you'll learn VBA essentials in just 15 minutes. First, you'll learn to set up the visual basic editor using the developer tab, and insert a new module to start coding. As a first scenario, we'll create a custom function to calculate discount percentages if a certain condition is true. Second, we'll create a sub procedure to clear the contents from a dataset in one click. We'll also add a message box and a button to confirm we want to clear the data. Finally, we'll learn to automate how to send an email from Excel containing a subject, a body, and the Excel file attached. Overall, learning VBA will boost your office productivity as you'll be able to autoamte any repetitive task.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
🎬 My Company KZfaq Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Excel VBA Introduction
1:50 - Building Custom Functions
4:40 - Automating Clearing Data
6:46 - Creating Message Box & Button
10:53 - Sending an email from Excel in 1 click
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 112

@KenjiExplains Жыл бұрын

🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! www.careerprinciples.com/courses/vba-macros-for-business-automation

@solomonbhandari-young4154 Жыл бұрын

incredible

@user-gg5pm9ws1o 3 ай бұрын

Your in which country

@user-gg5pm9ws1o 3 ай бұрын

I want to take courses

@NoelCarson Жыл бұрын

Your tutorials are a lifesaver for a new analyst. There are many more new tools like Alteryx which won't replace Excel but just makes life easier. Wish you could eventually make videos on those.

@guilhermeh.v.santos7424 2 ай бұрын

Amazing content in such a short video, straight to the point !! Thanks for sharing

@sharmilasanka2186 4 ай бұрын

Great and simple way of explaining. Thank you so much.

@user-cf1rx9zy2z 3 ай бұрын

Thanks Kenji for this video. I learned from you more.

@kanyaupoe 2 ай бұрын

Thanks so much for your efforts. Clearly understand. Really like your presentation style and English skill.

@ashimasingh7578 10 ай бұрын

Your videos are truly exceptional and the level of clarity in your communication is absolutely invaluable. We cannot thank you enough for the tremendous effort and skill you put into creating such helpful content.

@waleedalqubati3849 5 ай бұрын

Truth 👍

@user-qp1un7qo2d 28 күн бұрын

Brilliant stuff! Do you have a tutorial on how to create a macro to copy and paste into a summary table the various different outputs from a scenario manager please?

@francesdobbins2964 Жыл бұрын

Thank you, Kenji! Can you create more VBA tutorials? Have a good day.

@sergio_molinari 7 ай бұрын

Hi Kenji, helpful video. To reduce the vba code could you write? If Answer = vbNo Then Exit Sub , it's correct?

@pablojp3498 Жыл бұрын

Loved it. More vba please

@khawajarizwan7006 8 ай бұрын

Very informative thanks

@motopelamohapi4152 9 ай бұрын

Thank you. Kenji.

@anonymoususer4356 2 ай бұрын

Good video. Thank you.

@daveyvergara 9 ай бұрын

I swear, you have helped me tremendously throughout my career. THANK YOU SO MUCH!!

@JasonKilgrow 5 ай бұрын

That's cool. I didn't know you could do that.

@goodboy6724 11 ай бұрын

Thanks kenji ❤️

@user-ei4bv4et6h Жыл бұрын

Helpful informatiion

@hayderxyz0 3 ай бұрын

you are amazing thank you

@afzaalahmed9565 7 ай бұрын

Thank you, I have learnt how to create custom function. I use vba just for fun. I want to discuss another problem which I faced. I know excel can’t handle figure more than 15 correctly. I used “NumberFormat=“@“” to convert the digits into text format. It was OK then but when I multiply and product is more than 15 digits, it again turn into the format which don’t require. For example I want to multiply 1111111111111111(col A)x11111111111111111(col B) in Number format without any error. I hope you can do this. Thank you.

@Urf_Keshav Жыл бұрын

More vba please ❤

@Seawolf159 Жыл бұрын

Nice video. Annoyingly the email sending doesn't work with the new outlook.

@mr.write1433 6 ай бұрын

Which one is faster to calculate? If statement or vba?

@manojitdey3323 11 ай бұрын

i have a problem sir will u solve it? In a column if there is a holiday in a cell then function should merge that cell to next 7 cells like If C4=Holiday then merge cells C4:C10

@LivingGuy484 2 ай бұрын

For the last one, how do you adjust the code so it can handle saving if there's already a file with the name in the path? Example, if you need to change invoice detail immediately after saving PDF, does it automatically overwrite old file if you click button again or does it do nothing?

@poulinfranciscas2146 10 ай бұрын

Nice video. Thanks for sharing. Please share I want to send emails with multiple vendors at the same time.

@erickang3579 Жыл бұрын

I enjoyed this so much that I went ahead and purchased a full bundle course with the discount.

@HamdanYouTuber Жыл бұрын

Useful video, thanks

@KenjiExplains Жыл бұрын

Thank you!!

@HamdanYouTuber Жыл бұрын

@@KenjiExplains You're welcome

@stevetheanalyst Жыл бұрын

I was toldvba and macros are dying because of powwer query. As a financial analysts is it still importance. Thanks

@camlex6310 Жыл бұрын

More VBA videos please!!

@fengfuxu4822 6 ай бұрын

thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Printer.deviceName Next prt End Sub

@eldercleric 24 күн бұрын

can you set it up so that if you have a file up the custom function wil work accross all files?

@NerdsRunTheWorld Ай бұрын

Oh this is great

@pokrpork 7 ай бұрын

15 minutes video ,just good enough to study for my exam in 1 hour

@Juan-Hdez 4 ай бұрын

Very useful. Thank you!

@nhojareubla 8 ай бұрын

very informative thanks sir!

@abhikhaire9505 5 ай бұрын

Amazing Video. Must watch for basics of VBA

@user-pm3jy5pu5g 7 ай бұрын

How can fixed row & column in excel via vba code. But not change size via mouse & in option row & column width.

@drax432 4 ай бұрын

I wonder if microsoft has ever improved and enhance VBA language in terms of api and syntax

@Variedviews8711 Жыл бұрын

Hi Kenji, is there any site which sells the templates?

@brunotvthebrunochannel 2 ай бұрын

Hello I sell good excel templates for use

@jaedonbigbrain8700 10 ай бұрын

You are a genius bro :)

@nirvickdas7674 Жыл бұрын

Bro you underrated ❤ you are the best teacher

@Servants_Heart 9 ай бұрын

How much is the class?

@tato2493528 11 ай бұрын

never knew vba was this powerful

@TessHere 6 ай бұрын

Very useful examples. For the last example, you gave me an idea of sending a file on the laptop to the printer depending on what the answer of the user is (eg 1 then print docA, 2 then print docB, 3 then print both ). What would the dim for a printer be ? Thanks.

@jimo9555 4 ай бұрын

I don't think you'd need a DIM for the printer, you'd need one to determine which document you want to send to the printer e.g. DIM DocToPrint As String DocToPrint = _the name of the doc your user selected_ (which would be the result of your function, If 1 then print docA, ElseIf 2 print docB, ElseIf 3 then print doc C) doc C could just be a copy of docA inserted and saved into docB, or you could write a loop to print docA then print docB

@claudineyribeiro518 6 ай бұрын

Hi i liked your video a lot. I am also a VBA programmer in Brazil and just started my channel teaching how to use OpenGL with Excel VBA

@solomonbhandari-young4154 Жыл бұрын

thank you professor kenji

@KenjiExplains Жыл бұрын

Cheers Solomon lol 😆

@dhawalghia 5 ай бұрын

Hi Kenji, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?

@IarukaSkYouk Жыл бұрын

Kenji you are a GODSENT bro I'm so thankful for your teaching

@KenjiExplains Жыл бұрын

Haha thanks for watching!

@waleedalqubati3849 5 ай бұрын

You make everything thing easy and us eager to learn vba❤

@Tanzif_ishmam 7 ай бұрын

Interesting

@Daniel-dj7fh Ай бұрын

Assuming I'm in MS-Word. How do I read off a table, and then make parts of it disappear? And what is a good source to find this out, because MIcrosoft's website seems to be really poorly explained on what xy-function does and what can and cannot be included to it. As an example, I know of "function.Select" but what does it really do? No clue, like what am I selecting, the value or the text. And what does selecting do really?

@Daniel-dj7fh Ай бұрын

Here in Excel it seems pretty straight forward, there is one table. No clue how the code reads out "Quantity" or "Price" out of it, assuming it exists on multiple fields. And the rest is simple maths, no Dim Variable As int or Set Variable = xyz nonsense.

@messiahscent Жыл бұрын

05:51 Kenji, when you say, "this sign," which sign is it?

@KenjiExplains Жыл бұрын

Sorry it’s the : Colon sign

@srisridaran05 Жыл бұрын

Hi, When i run the email macro after coding i can see an error called "ActiveX Component can't create objects". Can you help me to solve this issue.

@nmahrunnisa 4 ай бұрын

me too, do you find the solution?

@nishanth4323 Жыл бұрын

Sensai....more vba video's 🙏

@KenjiExplains Жыл бұрын

Noted!

@vikramadityarathore97 Жыл бұрын

Keep up the good work!

@KenjiExplains Жыл бұрын

Thank you!

@sebastiankumlin9542 4 ай бұрын

Great explanation! VBA just seems so weak!

@antoniotruong5647 11 ай бұрын

"Sub ClearContent" is the name he gives and the "...ClearContents" is an actual command in VBA. Two different things.

@SalvadorGarcia-rt1kk Ай бұрын

Hi sir, how to enrol in the VB course and how much it cost, thank you.

@KenjiExplains Ай бұрын

Hey thanks for your interest. You can learn more here: www.careerprinciples.com/courses/vba-macros-for-business-automation

@ankitjadhav6775 8 ай бұрын

can we code it to undo our actions?

@khalilfuller4939 3 ай бұрын

Take a picture

@zorgitron 6 ай бұрын

Dude the background music makes me so hyped while I'm Typing in some VBA。

@KenjiExplains 6 ай бұрын

Hahaha let’s go 🚀😂

@eotppanpoli25 Жыл бұрын

7:59 Ada namma T.R

@harib7406 7 ай бұрын

😂😂

@hansgulbranson9506 Ай бұрын

My favorite part about this video was how confusing it was.

@michaelquach6655 Жыл бұрын

More VBA please 🙏

@KenjiExplains Жыл бұрын

Hopefully soon!

@brunocaruso1082 Жыл бұрын

Buy the course 🤣🤣🤣

@weike656 9 ай бұрын

Thanks Kenji, 12:38 how to send to 2 peoples email or cc another one email?

@mukeshkunkolkar5524 5 ай бұрын

Sub OpenDartFolder() Dim folderPath As String folderPath = "C:\Users\kunko\OneDrive\Desktop\Dart" Shell folderPath, vbNormalFocus End Sub i have written this VBA Code and assingned macro button to it but when i click or run the code an error occurs showing invalid procedure call or argument. what might be the problem please do help me it will be very greatefull of you. this code is used to excess folder present at any location in your pc using excel file and macro so please do help me

@JOHNNYKAZANDRE 15 күн бұрын

I want to be your disciple please advise.

@spring802007 5 ай бұрын

I tried it, shows ambiguous name!

@willzinner8813 Жыл бұрын

can you do a part 2?

@KenjiExplains Жыл бұрын

Noted

@micmv 6 ай бұрын

You could literally do this with a simple IF excel formula...

@followthescience5571 Жыл бұрын

16h ago? I don't want to be rude, but this is a bit late to the party isn't it? Apart from the pain of using this "IDE", most companies block or discourage the use of macros because of security concerns. There is already a javascript api in place for replacement. If you don't know VBA in 2023, don't bother!

@zizosaeed 11 ай бұрын

Talk to chatgpt and copy paste code is easy and fast don't waste your time in write code just learn how to edit code to face any problem

@anthoniasdfgh 6 ай бұрын

Lmaooooo jit tweakin

@Simplevids786 6 ай бұрын

Yes i also do same not wasting a single second go ask copy paste done

@Jcohen3503 6 ай бұрын

Bruh, wait til you accidentally get an error that you didnt edit out that deletes your data 😭

@pamuji_alfaruq 5 ай бұрын

True.

@rubixio8014 4 ай бұрын

I strongly believe your suggestion is not good. If anyone is trying to patch chatgpt code to build a project then I strongly advise they get a VBA fundamentals, this I a programming language with weird rules, one mistake could cost you your precious data if you don't have a good understanding of what you're doing