Starting with Excel VBA Code

[NeoPa]

One of the main reasons that Excel development is so easy to get into is that the Macro Recorder (Tools / Macros / Record New Macro...) can produce some (albeit pretty basic) code for you to look at and build upon.

Don't know the right object? Not sure of the right procedure? Excel can give you the tips you need to get into what you're wanting to do. As long as you know how to do something via the operator interface then you can find out quickly and easily at least one method of doing the same via code. The code built for you is pretty basic though. Not many developers with any pride at all will leave any in just as built, but nevertheless, the insight into what's available can prove invaluable as a start.

The Help system and your own capabilities are there to enable you to build on that. It really is a quick way to to get into the environment and become competent very quickly.

[JayF]

I've been using Excel for years but only recently learned anything about VBA other than of it's existence. I've not had time to really delve into Excel VBA yet - I'm too busy learning Access - but I look forward to first playing with it armed with your tips above.

Thanks Neo. The world is a little better for the 576 people who have read this post. If everybody on the planet shared their knowledge as freely and persistently as you and your fellow posters do, the world would be a hugely different place.