The 7 Keys Areas of Excel VBA (with code examples)

Every time I feel happy when I get an information that you uploaded a new video because I know that it is going to be very helpful and quite useful. Thanks indeed Paul. 👏 🌟 🌟 🌟

Thank you.

Sometimes I wonder what is the gain in VBA speed all over the world (and economical gain for that matter) thanks to these lessons.

Why shData not error "variable not defined" sir?

I would add 2 more areas to that:
Forms (developing apps) and classes/interfaces 😄

Thank you for the basics. I'm a bit confused, in the example you are Debug.printing the Dictionary results, but how do I transfer the results to Excel?

Thank you.. It was nice video..

Thank you so much paul.

AWESOME VIDEO! Perfect for finding yourself in this forest of knowledge!

Hi. I am getting Compile error: Variable not defined when I use sub UseRanges(). How to solve it?

Great channel! Thanks!

Dear Sir,
for the dictionary part,
if the value (amount) of the key (Fruit) is zero in sum, will it be shown in the dictionary?

i just wanna be using the dictionary for my inventory record, sometimes it may be zero in number.

Great, dictionary was new for me!

hello there ! General Kenobi !

Easy to follow and understand tutorial. Thank you

God of excel VBA..🙏

Is there a reason you use Long for the row in your dynamic ranges example? Naively I'd think that should be an integer; like, what would happen if you gave it a fractional value? I'm totally new to excel vba, so please forgive me if excel or vba does something I don't know about which makes this the best practice.

Ahh. I see that you've changed the name of the sheet to shdata. That answers my question.

ShData isn't an object, at least in Office 365 version of Excel.

Go raibh maith agat. An-úsáideach mar i gcónaí.

The example of the Ranges doesn't work and gives me the Run Time Error 424 and I have meticulously verified the code I typed to what is in the video. does anyone know why this would be? I'm currently on Office Home and Student 2016. Thanks in Advance.

But is the efficiency so much bigger working in VBA instead of working direct in the spreadsheet?

Question about the dictionary. The for each loop at the end you say currentKey in dict.Keys. The currentKey make sense cause you declared it as a variant. Where did the .Keys plural come from?

Please , i have this problem, my code
for i = 1 to 100
if worksheets(“sheet1”).cells(i,1).value = i ————this dont work
when i change i to 1 it works like this
if worksheets(“sheet1”).cells(i,1).value = 1———–work
i try convert the cell covert the every value no way , thanks

You are a Champ, thanks and God bless you.
✌😀

I really like your videos and respect your work... however, that has got to be the worst ever example of what a function is and how to use it.
Bro, the main reason you use functions is to be able to include them as part of formulas (i.e. a text formula that includes regular expresions) or to consult data from external DB's (a function that gets a Part Number from a DB of vendors). All without the need to include buttons or to map them on your interface, you just type = then start typing however you named your function and voila.

Amazing Video

Well done

You're a very gifted educator Paul. I've been programming for years in VBA, and you keep showing me all kinds of things I had no idea about. Excellent content taught in a very friendly manner.

Excellent video again, thanks!

Can u please give ur suggestions on how to use intellisense...
Some times it doesn't work and make feel worry sometimes..
Example.. Activesheet.paste will not be shown with intellisense... I know that it has to do something with object library...

Can u please make video how to use object library

Hi Paul, big fan of your channel. Do you do vba consultancy?

Hi Paul. It's amazing knowledge. Thanks for sharing.

Thank you for your video. I'm using vba for a while but learnt a lot from your video to simplyfy my code. Currentregion is a very usefull code i didnt know that realy like it. Nowdays im working with data where there are blank rows what i cant delete. Do you have any tool how to handle this type of database?

Thanks for making these videos, they've been extremely helpful to me! Clear, concise explanations in terms I can grasp, and the pace is spot on👍,subscribed.

Awsome video! If you want to, check out my channel where I show how you can turn Excel files into web apps without coding or extra software!

You are the KING of VBA

Can u please give ur suggestions on how to use intellisense...
Some times it doesn't work and make feel worry sometimes..
Example.. Activesheet.paste will not be shown with intellisense... I know that it has to do something with object library...

Can u please make video how to use object library

Can we use AND in case statement??... How do i write?? For example the below code doesn't work
case > 1500 and < 2000..

Nice video to refresh and revise ur understanding... Thanks paul

Hit like and watch the video

Excellenttttt..... Thanks for the video..

Well done Paul.
As always, very clear and didactic.

Thanks Paul.

Could you teach the use of listviews instead of listboxs?

Great , Thanks

Except the dictionary part I can say I know the other ones, but still I m afraid to apply for a vba developer job because I don t know which are the expectations ...

That was great. Saved off the link. I'd not heard of using CurrentRegion before. That'll be very helpful.

This must be some record - 3 days of VBA training squeezed into 28 minutes. Bravo!