VBA Programming e-course with Real-Life Projects - E03

Want to become VBA Pro? Here's a 100% free guided e-course with Real-life projects.

You can now support by buying any of the Projects or Source Code.

Please like, share, and comment to improve the channel algorithm

📌What to watch next:

#VbaA2z

The goal of this course is to bring absolute beginners up to speed with VBA Programming, by telling things only on a need-to-know basis and by using layman's terms. VBA is a great skill to have, especially if your automation targets office applications like Excel, Access DB, Outlook, PPT, Word, etc.. You'll also come to know that there are powerful libraries within VBA that help you connect to the web, servers, databases, build custom functions, interface, and much more. From my experience, the first step is most important and I'm here to help you get started.

[peterwooldridge]

explanation and application of loops l've seen on YouTube...Thanks!!!!

[susilsxzen-ffzn]

Learning a lot from this series. Thank you Pamai

[DaniSani-fq]

many thanks again. learned a lot from this practical series

[faridPQ]

You are a great instructor. Loved it so much

[chrish]

I always learn something new from your videos especially Userform. I never knew we can add customized controls as a template. Thanks and cheers my friend!

[VBAAZ]

Subscribe, Like, and Share.

If you missed prior lessons check below
Lesson-1:
Lesson-2:

Sign up to participate in this guided e-course, receive assignments, and certificate upon completion.

If you have any questions, please comment below.

[Eric-gzuw]

19:33, How about the Auto-filter copy? First, add the Auto filter, then select one as the condition, then copy the information after auto filter.

[dannylasso]

You're best mentor sir. thank you

[Bws]

Hallo Pamai, I have sent you the assignment. Thank you. :)

[levelupexcelskill]

Thank you so much Sir, We all are waiting for next episode please share with us. We all are thankful to you.

[roland]

Hello sir, excellent work.
Don’t forget the VSTO fans :D

[wennychez]

Thank you so much. Waiting for next lesson

[azel]

I really enjoyed your lessons and tutorials. Those practical examples that you use are perfect. Thank you so much for this and for your guidance

[romanromanchuk]

Hello Pamai. Thank you for such cool, thick information about VBA.
I am Roman, from Ukraine. I am 20 years old and I am only in a start of my programmer caree ( I am not even trainee).
And actually I have some several questions :
1) Is it rational to spend time in 2022 studying VBA when there is Python, which, as I heard, can replace almost everything that VBA can do?
2) And what you could recommend learn after VBA?
Thank you for your work.

[qwer]

Hello, Your tutorials are great. They've been a great help. Do you know the problem when a user opens a tool (userform) but due to the screen scaling some functions are deactivated? I have a multi-column listbox on a userform which works for all but two users. With them the HP monitor scales everything differently, the listbox moves and can no longer be clicked. Can you make a video about display and scaling of userform? That would be very helpful.

[holieh]

Another nice one. Keep up good work.
Please don’t forget VSTO :)

[beenay]

(31:00) the "shift:=xlup" or "shift:= xldown " in "insert shift:=xlup" does not seem to make any difference. even if i don't use "shift:=xlup" the result is the same . does "shift:=xlup " has any function here?

[ranganatharanga]

Can help me writing a VBA macro to change the font of cell when there is difference in text

[MrJustBeginning]

Hi. Where can I get the Transactions.xlsx sample file so I can do the Lesson3 Assignment 1. Thanks

[alessandroso]

Do we always have to debug.print cells when we do loops? Specifically in 20:41