Beginning VBA

[beamersoap]

Looking for advice. I have been working on teaching myself VBA. I have a ton of beginner books and I look at websites and forums. I am struggling because I feel as though I am missing structure. Would a intro to programming class benefit me or would it be a waste of time?

 

[Derek Brown]

Hello and welcome to The Board.
You may find the following link very useful:
http://www.mrexcel.com/forum/showpost.php?p=2676997&postcount=5

You did not say which version of Excel is being used:
If 2003 you could also look at http://www.mrexcel.com/store/index.php?l=product_detail&p=26 but I don't have it myself so cannot comment on how good it is (PowerPoint is needed to use it).
If 2007/2010 have a look at http://www.mrexcel.com/store/index.php?l=product_detail&p=168

 

[beamersoap]

Thank you for responding. I am curious if taking a programming class would be beneficial.

 

[Derek Brown]

Personally I think that it best to learn by working on a project and searching for suitable code/solutions when necessary.

I believe that more can be achieved from self-paced learning (see the links that I gave) - a course is likely to give you just the very basics and then you will still need to put it into practise to get a better understanding.

 

[Firefly2012]

I agree with Derek. Sometimes it isn't easy if you don't have a project to hand (eg from your workplace). Not that I would wish to recommend another forum site over this one, but you could consider visiting Experts Exchange - it is a paid for membership site but the last time I was there (which was a year or two ago) you could answer questions without paying. Because of the structure of the site, most of the question askers there expect a full solution to be provided (eg rather than gentle prodding in the right direction as often happens here) and sometimes the requiremnts are extensive. This could provide you with ready-made mini projects to tackle.

 

[beamersoap]

Thank you for your recommendations.

 

[Derek Brown]

This does not change m opinion as expressed above but just in case you are still looking for something, visit the following link:
http://chandoo.org/wp/vba-classes/