Learning Resources???

**antonymiller** · 07-14-2009, 01:20 PM

Hi all - I'm trying very hard to learn VBA. Progress is slow. I haven't done any programming for 10 years - and that was in Visual J++ for a college class. I don't remember any it.

What is the best way to learn this? That to the For Dummies series I understand some of the basics, Subs, Functions, Defining variables, even a little about array. However, putting any of it into practice with excel on my own for my uses is crazy.

I mean I can use the macro's others write but when I look at the code - it's still seems like jibberish and quite often I see code that I have no idea how to decipher.

Is there a book, a series of videos or anything that will teach me this language and how to use it from the ground up? I'd hate to think I'll never get any better.

Thanks

**JBeaucaire** · 07-14-2009, 01:30 PM

For me, the best way to learn is to decipher code that is doing something I want. This means I don't have to figure out the exercise, too, I already understand it intrinsically. It's much easier to see the correlation between how my need is being met and how the code is doing it.

Stepping through code one line at a time with F8 and looking at what is happening on the sheet and with the variable values is also very informative. While a macro is running in "step mode", you can hover your mouse over any variable in the code and see what it currently resolves to. Couple that with understanding what your macro is supposed to be accomplishing makes this much more absorbable.

That's it for me.

**excelkeechak** · 07-18-2009, 08:13 AM

I m also facing the same issue. It seems to me that i had got VBA into my mind.Practically,when it comes about writing own macros there are some difficulties.Its natural that it takes sometime to get around the Main Theme.

Any ways, anybody knows some sites or learning material then do post them.it would be very helpful for the new learners.

Coming to my side, i did some google searches regarding videos and to my help i found some in YOUTUBE.

anybody know any other info then do post them. thanks a lot.