The Select Case Statement
The Select Case statement lets your program make multiple choices based on the value of a single expression.
- Read more about The Select Case Statement
- Log in or register to post comments
Do...Loop Statement
The Do...Loop statement, or Do for short, is used to execute a block of statements repeatedly—in other words, to loop through the statements.
This statement comes in several variations that can meet essentially any program need.
- Read more about Do...Loop Statement
- 1 comment
- Log in or register to post comments
For...Next Statement
The For...Next statement repeats a block of code a specified number of times.
- Index is a variable that is used to count loop repetitions. It is usually declared to be type Integer.
- Start is an expression specifying the starting value of index.
- Stop is an expression specifying the ending value of index.
Optionally, For...Next can use an increment value other than 1.
- Read more about For...Next Statement
- Log in or register to post comments
Goto Statement
The Goto statement instructs program execution to go to the specified location in the code.
A label itself has no effect on program operation—it serves only as the target of a Goto.
- Read more about Goto Statement
- 3 comments
- Log in or register to post comments
Comments
A comment is text in a VBA program that is ignored and has no effect on the program operation. You can (and should) use comments to document how the code works, provide details about procedure arguments, and add reminders to yourself or another programmer.
- Read more about Comments
- Log in or register to post comments
Logical Operators
VBA has six logical operators:
- Read more about Logical Operators
- Log in or register to post comments
Comparison Operators
The comparison operators are used to perform comparisons between expressions. A comparison expression is actually a logical expression, evaluating to True or False depending on the data and operator used.
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
<> Not equal to
- Read more about Comparison Operators
- Log in or register to post comments
DateSerial()
Syntax: DateSerial(Year as integer, Month as integer, Day as integer)
The DateSerial function creates a Date value from separate month, day, and year values.
- Read more about DateSerial()
- Log in or register to post comments
DateValue()
Syntax: DateValue(StringDate as String) as Date
The DateValue function assignes a specific data to a type Date variable. Converting a string representation of a date into a Date value.
Parameters: The StringDate can be different date formats in string, the following are a few examples:
- "January 10 2007"
- "January 10" - defaults to current system year
- "Jan 10 2007"
- "10/Jan/2007"
- "10/01/2007"
- "10/Jan/2007 14:10:10" - won't return the time portion
- Read more about DateValue()
- Log in or register to post comments
Now()
Returns the system date and time as a type Date.
- Read more about Now()
- 3 comments
- Log in or register to post comments