Solved: Visual Basic Programming

[Dio]

Hi,

I'm thinking of taking an online class. One of the classes available is:
Visual Basic Programming I

Since I have to write macros now at work I thought that that class might help me. Will it? If not I'll just take something else.

Thanks,

Dio

[Bob Phillips]

Well, it depends upon your objectives and your knowledge. That course sounds as if it is simply a programmin g course, addressing the syntax and control techniques of that language. Nothing wrong with that in itself, and it gives you a good foundation, but in itself it doesn't help you much to program Excel. For that you need to understand the object model and the functionality that is packaged with Excel, in order to use them.

My view is that VB is really pretty straight-forward, and easily learnt. The Excel OM is a different beast, harder, but where the power comes in. And similarly with Word, Powerpoint, etc.

[Dio]

Thanks for the info, sounds like I don't need to take the VB class.

[Kenneth Hobs]

A basic class would be good if you don't know the basics of programming like Loops, Conditionals, Strings and File/Folder commands.

To get started in Excel VBA, this link should help. http://www.mvps.org/dmcritchie/excel/getstarted.htm

You may want to check out the various Excel forums. Many offer courses.