Microsoft Office Development and Consultancy
 Home|Excel|

VBA

|C#|Finance|Tools|Newsletter|Feedback|Contact 
 VBA > Syntax > Other

 
APPACTIVATEActivates an application or window currently running on Windows.
BEEPProduces a single beep noice.
CALLTransfers control to a procedure.
CALLBYNAMEReturns, sets or executes a method or property of an object.
CHOOSEReturns the value from a list of values based on an index number (Variant).
COMMANDReturns the argument portion of the command line used to launch the application.
CVERRReturns the corresponding to a given error number (Variant).
DOEVENTSPauses execution to let the system process other events.
ENVIRONReturns information about the current operating system environment ? (String).
ERRORReturns the error message corresponding to a given error number (String).
FORMATCURRENCYReturns the expression formatted as a currency value (String).
FORMATNUMBERReturns the expression formatted as a number (String).
FORMATPERCENTReturns the expression formatted as a percentage (String).
GOLINETransfers control to the subroutine indicated by the line label
GOSUBTransfers control to the subroutine indicated by the line label
IIFReturns one of two parts, depending on the evaluation of an expression (?).
IMPLEMENTSSpecifies an interface or class that can be implemented in a class module ??
INPUTBOXDisplays a dialog box allowing the user to enter some information (?).
IS*Object reference comparison operator ??
ISEMPTYReturns the value indicating if a variable has been initialised (Boolean).
ISERRORReturns the value indicating if an expression is an error (Boolean).
ISMISSINGReturns the value indicating if an optional argument has been passed to a procedure (Boolean).
ISNULLReturns the value indicating if an expression contains no data (Boolean).
ISNUMERICReturns the value indicating if an expression contains a number (Boolean).
LET??
LOADPICTURELoads a picture from a specified file for manipulation or placement into a Picture or Image control.
MACID??
MSGBOXDisplays a dialog box displaying a message to the user (Integer).
PARTITIONReturns the desired range of values. The number indicating where a number occurs within a calculated series of ranges (String)
QBCOLORReturns the RGB color corresponding to the specified color number (Long).
RAISEEVENTFires an event declared at module level within a class, form or document.
REMSpecifies a line of comments - same as ( ' ) character.
RGBReturns the number representing an RGB color value (Long).
SAVEPICTURESaves a graphic image from an objects Picture or Image property to a file
SENDKEYSSends keystrokes to an application
SHELLReturns the program's task id from running an executable programs (Double).
STOPSuspends execution
SWITCHReturns a value based on expressions ?? (Variant).
TYPENAMEReturns the datatype of the variable as a string (String).
VARTYPEReturns the number indicating the type of a variable (Integer).
 
 Note: * These are Operators

 © 2013 Better Solutions Limited. All Rights Reserved.Top | 02-Jan-2013