vba courses london - Coding Best Practices

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Coding Best Practices

Georgios has attended:
Excel VBA course

by - delegate Georgios [1 post] (2007 Jan 23 Tue, 16:31) Reply

Where can I find best practices for VBA coding...

RE: Coding Best Practices

by - trainer David gold contributer [428 posts] (2007 Jan 24 Wed, 14:27) Reply

Hi Georgios

I trust you found your Excel VBA course very useful.

With regards to the best practice for VBA coding, you will find many books available that deal deal with VBA coding. The main things to keeps in mind is to always comment your code, so that it is clear for other people to understand and to use meaningful variable names.

Hope this helps

David

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Introduction to Visual Basic for Applications
· Should You Send Managers To VBA Training?
· How To Find A Good VB For Access Trainer
· Visual Basic Returns To The Macintosh

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips

Rate this page: