Standards and tips for VBA

[NateBuckley]

Hello, I've been learning VB and VBA for about a month and a bit now and I
work alone so have had to pick up everything on my tod, no doubt that also
involves some bad programming practices. I'm just wondering if anyone can
reply with tips, standards and anything else that may be useful and along
those lines.

Thank you.

 

[paul.robinson]

Hi
1. Look at this newsgroup every day. You learn a lot.
2. Search this newsgroup before asking a question. It has probably
been answered many times before.
3. Get a good book. Excel 2002 VBA (2003...) by Stephen Bullen at al,
published by Wrox Press is very good. Also any VBA book by John
Walkenbach.
4. Go to John Walkenbach's site - he has a very good VBA tips page.
There are others too - Stephen Bullen, Tusha Mehta, Ron de Bruin (get
his Google Search Add-In with its built in favourites list), Debra
Dalgleish and Chip Pearson amongst others.

regards
Paul

 

[Jon Peltier]

I've posted a set of short how-tos on my blog, starting with this:

http://peltiertech.com/WordPress/2008/03/09/how-to-use-someone-elses-macro/

I also have a number of VBA related posts on my web site:

http://peltiertech.com/Excel/Charts/ChartIndex.html#V

There are two VBA programming tools I use more than any other:

Google
Macro Recorder

Here are some programming books that I own and use:

http://peltiertech.com/Excel/xlbooks.html#ExcelVBA

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Hi
1. Look at this newsgroup every day. You learn a lot.
2. Search this newsgroup before asking a question. It has probably
been answered many times before.
3. Get a good book. Excel 2002 VBA (2003...) by Stephen Bullen at al,
published by Wrox Press is very good. Also any VBA book by John
Walkenbach.
4. Go to John Walkenbach's site - he has a very good VBA tips page.
There are others too - Stephen Bullen, Tusha Mehta, Ron de Bruin (get
his Google Search Add-In with its built in favourites list), Debra
Dalgleish and Chip Pearson amongst others.

regards
Paul