
Fix 
This a numeric function that truncate the decimal
part of a number and return an integer. For positive number, it
is the same as the function Int, but for negative number, Fix
return an integer larger than the number. e.g. :
Fix(5.46)= 5, but Int(5.46)=6 
For.....Next 
This is a looping procedure. Example1: For i=1 to
10
x=i+1
Next i
Example 2:
For i=1 to 100 step 2
x=i+4
Next i

Function 
Use to create userdefined functions. The Format
is
Function function_Name(Arg as dataType......)
Statements
End Function
Example:
Pubic Function BMI (h as single, w as single)
BMI=w/(h^2)
End Function
To call the function, just use another variable
and assign the function to it like yourBMI=BMI(x,y),
where the values of x and y can be accepted through an InputBox
or text boxes.

Format 
Format is a function that is used to format
userdefined output or styles. The general format is Format(number,
"user's format")
Example 
Explanation 
Output 
Format(1234.5,"0") 
Rounds to a whole number 
1234 
Format(0.657,"0.0%") 
Converts to percentage form with decimal
places 
65.7% 
Format(12345.6789,"#,##0.00") 
Rounds to 2 decimal places with
separators between thousands 
12,345.68 
Format(12345.6789,"$#,##0.00") 
Shows dollar sign and rounds to 2 decimal
places with
separators between thousands 
$12,345.68 






