When small informational messages or simple questions need to be asked, the MsgBox (message box) function can be used. A primary advantage of using a message box is that it lets you present a message to the user that can't be ignored. The syntax of a message box statement is shown here.
MsgBox (prompt [, buttons] [, title][, helpfile, context]) as Integer
Prompt A required argument for the MsgBox function that contains the text that is displayed within the message box.
Buttons Optional numerical argument used to specify the buttons and the icon that is to be displayed within the message box.
Title Optional string argument used to specify the text to be displayed within the message boxes title bar. If omitted, ?Microsoft Office Excel? is displayed.
Helpfile Optional string argument used to specify the help file used to provide context-sensitive help.
Context Optional numerical argument that is the Help context number assigned to the appropriate Help topic.
If a Cancel button is displayed in the message box, pressing Esc has the same effect as clicking it.
The simple message box can be displayed as following
Sub Welcome ( )
MsgBox (?Welcome To Excel?)
End Sub
Input Box
An input box is similar to a message box in that it displays text, but it has the additional functionality of being able to accept text responses from users. Instead of presenting the user with a few buttons that can be clicked in response to messages displayed in the window, input boxes contain a text box where the user can type in responses.
Prompt Required argument for the InputBox function that contains the text that is displayed within the input box.
Title Optional string argument used to specify the text to be displayed within the input boxes title bar.
Default Optional string value that is displayed within the text box as the default value if no other information is entered.
Xpos Optional numeric expression that represents the number of twips from the left edge of the screen to the left edge of the input box.
Ypos Optional numeric expression that represents the number of twips from the top edge of the screen to the top edge of the input box.
Helpfile Optional string argument used to specify the help file used to provide context-sensitive help.
Context Optional numerical argument that is the Help context number assigned to the appropriate Help topic.
The InputBox function returns a string value, so if the text box is blank or the Cancel button pressed, the returned string is empty. The returned value from an input box is usually stored within a string variable so that it can be processed further.
Public Sub Example ( )
Dim StrInput as String
Dim StrResponse as String
StrInput = InputBox ("Please provide the text for Message Box", "Input Box Example")
Shailendra Singh has sinced written about articles on various topics from Software, Search Engines and Software. We are the fastest growing human edited web directory in the world. Listing of new website in 48 hours on static html pages with static text links.. Shailendra Singh's top article generates over 12100 views. to your Favourites.
Cost Of Advertising In Magazines How many potential customers you would attract, only if you learnt the art of advertising. Think of it!