Presentation - The Code

Page visited 12286 times

 
1. A program can have one or several Procedures
Excel-Exercise-Tutorial-1
 
 
 
2. The 'Keyword' (Sub, End Sub, If, End If, ...) are most of the time in blue and the color is differente of the color of the variable
Excel-Exercise-Tutorial-2
 
 
 
3. You can change the color and the format in the menu Tools/Options tab 'Editor Format'
Excel-Exercise-Tutorial-3
 
 
 
4. In order to have a document more readable, it is advocate to tab the lines include in a Loop or a Condition

You can tab line by line or for a series of rows
Excel-Exercise-Tutorial-4
 
 
 
5. The comments are very useful to explain the function of the variables and the mean of a condition

To make a comment, you just have to put a quote before your text, or click on this icon.
Without the quote, the program attempt to read the comment and will cause an error.
Excel-Exercise-Tutorial-5
 
 
 
6. The icon is very useful for a series of rows.
If the toolbar 'Edit' is not enabled, make a right-click on the grey of the toolbar, and select 'Edit'
Excel-Exercise-Tutorial-6