VB Language
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
Hour()
Hour(date) Returns a value 0–23 representing the hour of the day
- Read more about Hour()
- Log in or register to post comments
If...Then Statement
The If...Then statement, or If statement for short, is used in a program to execute a block of code if a specified logical condition is True. If condition is True, the statements in the block (indicated by block1) are executed. If condition is False, they are not executed.
- Read more about If...Then Statement
- Log in or register to post comments
Int()
The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer. The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.
- Read more about Int()
- Log in or register to post comments
Integer
Name: Integer
Type: Integer
Range: -32,768 to 32767
- Read more about Integer
- Log in or register to post comments
Integers
Numbers with no fractional part.
- Read more about Integers
- Log in or register to post comments
Log()
This function calculates the natural log (base e) of the specified number. The value that is returned is of a type double. To see an example of how to calculate the log of a base 10 see the snippets section.
- Read more about Log()
- 2 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
Long
Name: Long
Type: Integer
Range: -2,147,483,648 to 2,147,483,647
- Read more about Long
- Log in or register to post comments
Minute()
Minute(date) Returns a value 0–59 representing the minute of the hour
- Read more about Minute()
- Log in or register to post comments