5 Things I wish I knew When I started using Excel VBA

Brilliant! I've been (casually) coding VBA in Excel for >20 years and I didn't know some of these! Doh! Please keep doing "Another 5" videos until you run out of ideas. :) Thank you!

all tips are very usefull,thanks!

Assalamualaikum sir i am toufikul alam from dhaka bangladesh. Brilliant idea. i am fan of you vba tutorials. greet thanks

HaHa! I am at a basic level, so this is so vital for me, as I am already guilty of doing the long winded methods.
I am begining to realize as human, our logical construct is sequential, whereas the code logic handles in blocks. Would that be an accurate assessment?

Oh wow... Code Names just blew my mind right now.

i'm late but still wanted to say thank you for these tips. each and everyone of them is pure gem

I can fill an array by just giving it the range? surprised Pickachu face

I have been an intermediate VBE coder for years (do not want to be advanced) - but your channel is great.

Very nice. I was literally trying to solve the "user changes sheet name" problem with out locking down the entire workbook and #1 fits the bill perfectly... Not to mention the rest of these tips are great too!

I've been using (and learning) vba for many years and only recently learned about Debug Compile from this video, I used it (along with Option Explicit) on my Personal.xlsb workbook and it took me days to clean up the code! Great tutorials

Please suggest, how to start writing a VBA Macro Code, I just know how to record macro only, pls help for further learning.

Thanks so much

Great job. Great teacher!

thankyou

Literally started vba this month and found this priceless 🙂. As are your others, especially those relating to error handling.

Many thanks. Especially the array part. I shed a tear. Happiness? The fact I wasted so much time in the past? It is just the powerfull simplicity at the end.

Brilliant advice!

Thank you for this straight forward tutorial.

I am indonesian.
would you please give the running text in your videos. so I can find the specific word to understand wll the meaning from your explanation. thank you so much.

This guy is the best out there by far. For anyone trying to learn VBA for Excel, start here.

I love your calm pleasant speaking style. Bonus is succinct, well organized steps of instruction. I give an A+ to this Instructor.

What a hack!

Omg that codename is very useful thanks. Of course everything in excellent keep on videos like this

Hi. Congrats for the video. Great delivery. I tested the codename technique, but it does not work with the codename, I get an error "execution timeout 424 - object needed". These codes work on macs too? . Any ideas? Thanks

Nice, I knew 2 out of 3! Good video thx

Thanks for this great video! Sorry for commentating bit randomly but i was hoping to find the answer here. Is there a possibility to run code from the personal.xlsb without having it opened? Maybe stupid question but im just starting with VBA. Thanks
Tim

Nice video 👌

Can someone please guide me how it is useful while converting range data to array?

Great videos Paul. Have helped me a lot. Thank you. If the user makes a copy of the worksheet in the same workbook, so there are now two worksheets in the workbook, the second worksheet is given a new codename. Is there a way to make the VBA work with this second sheet?

1st and 3rd one are easy and brilliant. i never knew that. it would be very helpful. thxs

Great Video! Thanks for sharing your knowledge!

Is there a way to change the code name of a sheet using VBA? For example, let's say I'm creating a new worksheet within a workbook. Instead of the sheet being called "Sheet10(Name)", can I give it a code name as well as a name, in case my oh-so-brilliant users rename the sheet?

Why split instead of Text to Columns please?

Well i learned arrays from you so what you showed about the ranges wasnt new for me. But the debug part, i confess that i knew but dont use it. 🤦🏻‍♂️🤦🏻‍♂️🤦🏻‍♂️🤷🏻‍♂️🤷🏻‍♂️🤷🏻‍♂️

like!

Thanks all 5 were new information for me. Thanks for sharing your invaluable knowledge!!

Thank you so much, this is life saver.

Worksheet code name just solved a problem I was thinking about. Thanks!

Thank you so much for this video!

Using dim arr as variant worked but did not display in the watch window? Any ideas.

Hi, yes that would have been really great to know at the beginning already. Thanks a lot for sharing! 🙂

Hi, super useful videos... slowly making my way through all of them. In many of your videos i see you type shData.Range and this is picked up. I get the error that the variable is not defined. What am i doing wrong?! Can anyone help?

How were you able to click away from the line where you have declared "arr=" without getting an error message?
Drives me nuts, everytime I just want to copy something, it freaks out that I didn't finish the line.

Paul, Taking a step back to see the fundamentals is an interest tour. I wish I had taken that step almost two decades ago. VERY well done. Thanks. Always a pleasure to "see" you.

Excellent thanks a lot

I am literally beating my head against the wall. Why did I not know this array thing!

OMG! Fantastic!

The range to array is "wow"