want to learn VBA(for excel)

[Semidevil]

so I want to learn VBA for excel, but dont know where to start. I searched online and went to the bookstores and found some sites and books. A lot of them dont really explain how to program in VBA.

They all just say "to do this, type this..."

it seems that I haven't found any site or book that provides the foundation for me to write my own code. I want to know what each of the keywords mean and when it is applicable to use it and when it is not. Everything I've found seems to just expect me to memorize a block of code for a particular function.

Am I just looking at it the wrong way? Does anyone know any sites that provides basic VBA tutorials??

 

[reverend boltron]

I think you can search around for some VB to get the basic understand of VBA and then once you have a grasp on those concepts you can have a firm foundation to start getting into the 'A' part of VBA. Check out your local library for VBA Programming for Dummies.

I worked at my local library when I was still stateside and got some great VBA experience. I was in the computer department, and we used VBA to run the whole computer center. It was pretty neat. We maintained and added on to the program according to our needs and wants. That was a really neat project that we had. Anyway, the guy who originally started the project before I took it over brought in the people who he works for now for his interview with them. He just showed them the program what it did, and how he did it, and they hired him on the spot. I think he's making six figures now. Pretty crazy, eh?

 

[mayest]

VBA is pretty simple if you have some programming experience. The online help is very good. I suggest that you start by recording a few macros and look at the code. That will give you an idea about the object model. Then, go buy a book. My suggestion is to get Walkenbach's Excel 200x Power Programming with VBA. If you don't have any programming experience, then one of the Dummies books will probably be a great help.

 

[computerechousa]

You are probably a newbie...so u need video guide or dummies book to start.

i just googled vba video tutorial and found this:

Visual Basic for Excel Training CD
104 Lessons- Video run time: 8 Hours
http://www.computer-training-software.com/mvbex.htm

i have not used this so cant really say abt the quality of video ....but still it is the EASIEST
route.

 

[Gibson486]

I think excel actually has a good tutorial. That's how I learned it.