I completely agree, and in the spirit of “Recruit a new VBA programmer” week, I would like to hear how you got started in VBA.
- What books did you use?
- What courses did you attend?
- Did you have an on-site expert to help?
- Did you use MS help?(could you find it?)
- When, and which version did you learn on?
- Maybe you havent learnt, in which case do you have a plan?
- If you have no plans to learn VBA, why not?
- oh, and why did you learn VBA?
I learnt VBA in Excel 5.0 when it was first introduced (1995?). I had already done some XLM, VBA was a BIG change.
I used some deadly dull teach yersen in 21 days type book initially. Then I spent about 10 years with the help constantly open. Then t’intawebs happened and I now go to Google first help second. Can’t remember when we got broadband but even MS help is better than a dial up to Google.
I learnt VBA to escape the monotony of management accounting, after 30 odd period ends I was truly sick of the same accruals and prepayments the day before, and the same sales, gross profit reports after.
At one place I worked my colleagues were concerned that my desk was full of technical books ‘you’re meant to be the expert’ they said. Accepting that you don’t already know everything is perhaps the first step to becoming an expert.
I have never been on a VBA course, although I have now taught plenty. Never had an on-site expert I could bounce ideas off, although more recently I have often been in a team of multiple devs which is great.
My most recommended VBA book would be Excel VBA Programming for Dummies
Mainly because it dives right in there with real world useful stuff without boring you to tears with anal levels of background/foundations.
I guess this is the latest version for all you ribbon lovers Excel 2007 VBA Programming for Dummies.
If after that you think VBA is something you want to persue further, then is the time to dredge through all that tedium about datatypes etc. We’ll cover that ‘next steps’ in another post later.
What about you?