Category - VB-Theory

Value, IsNullReturns a Boolean value that indicates whether an expression contains no valid data (Null).SyntaxIsNull(expression)The required expression argument is a Variant containing a numeric expression or string...

String, Left and Right functionsReturns a Variant (String) containing a specified number of characters from the right side of a string.Syntax : Left(string, length) | Right(string, length) Example:dim AnyString...

Miscellaneous, MsgBoxDisplays a message in a dialog box, waits for the user to click a button, and returns an Integer indicating which button the userSyntaxMsgBox(prompt[, buttons] [, title] [, helpfile, context]) The...

Math, Val functionDescriptionReturns the numbers contained in a string as a numeric value of appropriate type.SyntaxVal(string)The required string argument is any valid string expression.The Val function stops reading...

Loop conditional, If…Then…Else StatementConditionally executes a group of statements, depending on the value of an expression.SyntaxIf condition Then [statements] [Else elsestatements]Or, you can use the...

Logic, Mod OperatorSyntaxresult = number1 Mod number2The Mod operator syntax has these parts: PartDescriptionresultRequired; any numeric variable.number1Required; any numeric expression.number2Required; any numeric...

File Folder, DirReturns a String representing the name of a file, directory, or folder that matches a specified pattern or file attribute, or the volume label of a drive.SyntaxDir[(pathname[, attributes])]The Dir...

Error Handling, On Error StatementEnables an error-handling routine and specifies the location of the routine within a procedure; can also be usedto disable an error-handling routine.SyntaxOn Error GoTo lineOn Error...

Declaration, Function ProceduresDeclares the name, arguments, and code that form the body of a Function procedure.Syntax: [Public | Private | Friend] [Static] Function name [(arglist)] [As type][statements][name =...

Date/Time, DateReturns a Variant (Date) containing the current system date.Syntax: DateRemarksTo set the system date, use the Date statement.Date, and if the calendar is Gregorian, Date$ behavior is unchanged by the...