Excel VB documentation and coding asistance

[John]

Where do I find documentation that will tell me what all the Excel VB coding
functions are?

Is there some way I can get or use the Excel 2007 VB editor to be a little
more helpful producing correct code?

This might help me to figure out more things on my own and not bother forum
experts so much. I'm pretty green at this VB thing, but am a good learner.

Thx for your help, John

 

[JLGWhiz]

Alt + F11 should open the VB Editor. Then you can click on Help and look for
the manuals provided by microsoft. If they do not appear at the top of the
Help menu panel then you might have to click a left or right arrow at the top
of the panel. At least that is the way it is in xl2003. I do not have
xl2007, so the panel layout could be different. Anyhow, once you find the
manuals, open them up and start reading.

 

[JLGWhiz]

Check this site for better info on getting into the macro area for xl2007.

http://office.microsoft.com/en-us/excel/HP100141121033.aspx

 

[Paul Wilson]

John,

If you are keen to go beyond the macro recording level there are tons of
sources of information.
There are help files to be found in the VB Editor. You may have to install
them from the installation
disk if they have not already been done.

Next there is the Excel 2007 developer information on
http://msdn.microsoft.com/en-us/library/bb979621.aspx

Also there is a whole body of information on the net which has been lovingly
contributed by all those
wonderful Excel geeks over the past 15 years or so. Excel vba has been
around since version 5 (1992?);
so most of the vba appertaining to 2007 was around in earlier versions. So
just google around with How-do-I... in-Excel vba.

A couple of my favourite sites are A daily dose of Excel
(http://www.dicks-blog.com/) and Chip Pearson's site
http://www.cpearson.com/excel/MainPage.aspx

Also it is well worth buying a book or two to help you on your way.

There is a steep learing curve, but it is well worth it if you persist.
Before you know it you'll be the office guru.

Good luck.

Paul

 

[Jon Peltier]

In the VB Editor, press F2 to open the Object Browser. This is the most
comprehensive source of information on the objects, methods, properties, and
events in Excel. To get more in-depth information and examples, clicking on
the hyperlinks opens the relevant page of the help files (well, usually the
relevant pages, and sometimes the examples are helpful).

- Jon

 

[Harald Staff]

Also; go Tools Options in the VB editor and check "Require variable
declaration". This puts Option Explicit on top of your new modules.
Backside is (surprise) that you must declare all variables and be careful
with ypur spelling, bonus is better intellisense and more helpful error
messages.

HTH. Best wishes Harald