Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » List of VBA coding

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

List of VBA coding

Resolved · Low Priority · Version 2003

Reply Thu 19 Feb 2009, 16:35Delegate Elisa said...

Elisa has attended:
Excel VBA Intro Intermediate course

List of VBA coding

is there a list of VBA coding we can refer to, because if you don't use it too often, it's hard to remember all the codes.

For upcoming training course dates see: Pricing & availability

Reply Mon 9 Mar 2009, 11:04Trainer Carlos said...

RE: List of VBA coding

Hi Elisa

For a glossary of VBA code in Excel:

1. Click on the Help button

2. The Help Task pane appears on the right of the screen

3. Click Table Of Contents

4. In the List click Microsoft Excel Visual Basic Reference

A list of folders containing VBA references appears

Alternately you can look arond for VBA books that are produced by Microsoft, although most of them are general Visual Basic Reference books and not specific to Excel VBA this is not a problem as the code is essentially the same.

Hope this helps

Carlos

Tue 17 Mar 2009: Automatically marked as resolved.

Excel articles

· Discover How To Use Fill In Excel
· Create Contrasting Coloured Rows In Excel
· Save time with Microsoft Excel
· Creating Error Alerts In Excel Using Data Validation
· Some Lesser Known Time Saving Tips In Excel

Please browse our web site to find out more about
excel training program and other Microsoft training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips