Basics of VB Programming
Message Boxes are used to display information to the user. You see them all the time in Windows and other programs.
Message boxes can be called like this:
MsgBox Prompt, Buttons/Icon, Title
The prompt is basically what you want it to say, the buttons/icon is what buttons you want and which icon you want and title is really self explanatory. e.g.
Msgbox "This is a test.",vbCritical,"Title"
You can use the following constants for buttons:
and these constants for icons:
An important thing that you need to be able to do is to translate what the user has done. e.g.
Dim iRes As Integer iRes=MsgBox("Test Question?",vbYesNo+vbQuestion,"Title" If iRes=vbYes Then Msgbox "The Yes button was clicked." Else Msgbox "The No button was clicked." End If
To include the contents of a control, such as a text box, you can use the ampersand character (&) to concentate the prompt string (see No Strings Attached). e.g.
Msgbox "The contents is:" & Text1.Text
Page 2 of 6