chunk777
07-03-2007, 05:30 AM
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
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