Learning Excel & VBA

Learning Excel & VBA

My canadian collegue Pierre Leclerc has published some outstanding tutorials on his website :

a) a site on Excel formulas:

http://www.excel-examples.com/00-excel-functions-sitemap.htm/

b) a site on Excel Macros (VBA):

http://www.excel-vba.com/


His Tutorial on Excel Macros is divided into 3 parts :

§1. - Excel Macros Programming (Chapters 1 to 10)

This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).

 

§2. - Excel VBA Vocabulary (Chapters 11 to 23)

Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).

 

§3. - Forms and Controls in VBA for Excel (Chapters 24 to 33)

The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.

 

You can download the tutorial at :

http://www.excel-vba.com/vba-excel-download.htm

Believe me: if you do practise all of these lessons, you will be "empowered", as Pierre uses to say : I mean you will become actual Excel gurus !.


Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

colorbar


Contacts...

E-mail : affordsol@skynet.be

Phone : 32+ (0)67 340 350 - Fax : 32+ (0)67 340 351 - Mobile : 0477 814 201

TVA (VAT) : BE0 669 361 168

Snail Mail :

Affordable Solutions

Rue du Nouveau Monde, 48

B-7060 - SOIGNIES

Belgique

Kilroy site by Affordable Solutions


Previous page: Contacts
Next page: Excel Ribbons