VB & VBA in a Nutshell: The Language

A.13. Interaction Functions

AppActivate Statement

Gives the focus to a specified application

Beep Function

Sounds a note through the computer's speaker

Choose Function

Returns a selected value from a list

Command Function

Returns the argument portion of the command line as a variant

Command$ Function

Returns the argument portion of the command line as a string

CreateObject Function

Returns a reference to an ActiveX component

DeleteSetting Statement

Deletes a given setting in the registry

DoEvents Function

Passes control to Windows to allow the system message queue to be purged

Environ Function

Returns the value assigned to an environment variable as a variant

Environ$ Function

Returns the value assigned to an environment variable as a String

GetAllSettings Function

Returns all values from an applications key within the registry

GetObject Function

Returns a reference to an ActiveX object

GetSettting Function

Returns a specific value from an applications key within the registry

IIf Function

Returns one of two values based on a Boolean expression

InputBox Function

Returns user input from a simple dialog box

MsgBox Function

Returns the user selection of a choice of buttons on a simple message box

Partition Function

Returns a string indicating where a number occurs within a series of ranges

SaveSetting Statement

Saves a value to the registry within the application's key and given section

SendKeys Statement

Replicates a keystroke in the active window ...