Can any one recommend a VBA course?

[chunk777]

Hi all,

My focus is Excel VBA and I apply it in an accounts environment.

Can any one recommend a part time course in VBA either online or in North London?

The majority of courses I find when I search on Google are 1 or 2 day courses for £500, which I am not interested in. I would prefer something more progressive and in-depth.

I have been teaching myself VBA for Excel and have progressed to a point where I can manipulate recorded macros and apply code from the internet into my procedures. I have built some productive automated excel reports. I have made good use of loops, for each i, pivot tables, message/input boxes, error handling and basic forms.

Unfortunately I feel like I am missing the fundamentals of VBA and I waste a lot of time on trial and error. I am positive I am not benefiting from the full features available in VBA.

Should I focus on a VBA or would an online Visual Basic course be suitable to cover all that I need? Would a Visual Basic course contain too much that is not relevant to VBA?

Where does VB.Net fit into the picture?

If anyone has any ideas, recommendations or can let me know where they obtained their knowledge of VBA I would be grateful

Thanks

 

[shades]

Howdy. Two books are essential in this:

Excel VBA Power Programming by John Walkenbach

VBA and Macros for MS Excel by Bill Jelen [Mr. Excel] and Tracy Syrstad

Also, if you are in London, there are quite a few Excel MVP's that would know of training. Check out Patrick O'Beirne, with schedules, Andy Pope, Roy and Jack.
________
Jugallette