JayasheeMiscellaneous,
MsgBox
Displays a message in a dialog box, waits for the user to click a button, and returns an Integer indicating which button the user
Syntax
MsgBox(prompt[, buttons] [, title] [, helpfile, context])
The MsgBox function syntax has these named arguments:
| Part | Description |
| prompt | Required. String expression displayed as the message in the dialog box. The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used. If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return – linefeed character combination (Chr(13) & Chr(10)) between each line. |
| buttons | Optional. Numeric expression that is the sum of values specifying the number and type of buttons to display, the icon style to use, the identity of the default button, and the modality of the message box. If omitted, the default value for buttons is 0. |
| title | Optional. String expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar. |
| helpfile | Optional. String expression that identifies the Help file to use to provide context-sensitive Help for the dialog box. If helpfile is provided, context must also be provided. |
| context | Optional. Numeric expression that is the Help context number assigned to the appropriate Help topic by the Help author. If context is provided, helpfile must also be provided. |
Settings
The buttons argument settings are:
| Constant | Value | Description |
| vbOKOnly | 0 | Display OK button only |
| vbOKCancel | 1 | Display OK and Cancel buttons. |
| vbAbortRetryIgnore | 2 | Display Abort, Retry, and Ignore buttons. |
| vbYesNoCancel | 3 | Display Yes, No, and Cancel buttons. |
| vbYesNo | 4 | Display Yes and No buttons. |
| vbRetryCancel | 5 | Display Retry and Cancel buttons |
| vbCritical | 16 | Display Critical Message icon |
| vbQuestion | 32 | Display Warning Query icon |
| vbExclamation | 48 | Display Warning Message icon |
| vbInformation | 64 | Display Information Message icon. |
| vbDefaultButton1 | 0 | First button is default. |
| vbDefaultButton2 | 256 | Second button is default. |
| vbDefaultButton3 | 512 | Third button is default. |
| vbDefaultButton4 | 768 | Fourth button is default. |
| vbApplicationModal | 0 | Application modal; the user must respond to the message box before continuing work in the current application. |
| vbSystemModal | 4096 | System modal; all applications are suspended until the user responds to the message box. |
| vbMsgBoxHelpButton | 16384 | Adds Help button to the message box |
| VbMsgBoxSetForeground | 65536 | Specifies the message box window as the foreground |
| vbMsgBoxRight | 524288 | Text is right aligned |
| vbMsgBoxRtlReading | 1048576 | Specifies text should appear as right-to-left reading on Hebrew and Arabic systems |
Shell
Runs an executable program and returns a Variant (Double) representing the program’s task ID if successful,otherwise it returns zero. button the user clicked.
Syntax
Shell(pathname[,windowstyle])
The Shell function syntax has these named arguments:
| Part | Description |
| pathname | Required; Variant (String). Name of the program to execute and any required arguments or command-line switches; may include directory or folder and drive. |
| windowstyle | Optional. Variant (Integer) corresponding to the style of the window in which the program is to be run If windowstyle is omitted, the program is started minimized with focus. On the Macintosh (System 7.0 or later), windowstyle only determines whether or not the application gets the focus when it is run. |
Add comment