VBA Interaction Module

Member Description
AppActivate Activates a given application window.
Beep Makes a beep sound.
CallByName Calls a specified method of a given object or sets or returns a property of the object.
Choose Returns a value from a list given an index value.
Command *Not available in Microsoft Office applications.
Command$ *Not available in Microsoft Office applications.
CreateObject Instantiates a class from a given ProgId.
DeleteSetting Deletes a section or key setting from an application's entry in the Windows registry or, on the Mac, information in the application's initialization file.
DoEvents Allows the operating system to process other events.
Environ Returns the value of an OS environment variable. *Not available on Mac.
Environ$ Returns the value of an OS environment variable as a String. *Not available on Mac.
GetAllSettings Returns a list of key settings and their values, originally created with SaveSetting, from an application's entry in the Windows registry or, on the Mac, information in the application's initialization file.
GetObject Returns a reference to a given object.
GetSetting Returns a key setting value from an application's entry in the Windows registry or, on the Mac, information in the application's initialization file.
IIf Returns the result of the truepart expression or the result of the falsepart expression depending on the outcome of a conditional expression.
InputBox Prompts the user for input. *Not the same as Application.InputBox.
MsgBox Displays a message popup with buttons the user can click.
Partition Returns where a number occurs within a calculated series of ranges.
SaveSetting Saves or creates an application entry in the application's entry in the Windows registry or, on the Mac, information in the application's initialization file.
SendKeys Sends keystrokes to the active window. *Not the same as Application.SendKeys.
Shell Runs an executable program. Returns the program's task ID if successful; otherwise, returns zero.
Switch Evaluates a list of expressions and returns the value associated with the first expression in the list that evaluate to True.