The Excel MsgBox function is a useful function to use to present output messages to the user. It also allows you to obtain input from the user, which you can build into your function.
MsgBox( Message to the user , Buttons you require, Title for the message box, Help file index if you want tie the message to a help file )
Now for an example. Let’s assume we want to reverse a string on the active Excel worksheet. However we first want to ask the user if he/she wants to proceed with the execution of the code prior to running the code module.
Dim StringToProcess As String ’The variable that will contain the string to be evaluated
Dim Response As Long ’The variable to receive the user input
StringToProcess = ActiveSheet.Cells(2, 1).Value ’Assigns the value contained in the active cell to the string variable
Response = MsgBox(“You are about to reverse the string. Are you sure you want to continue?”, vbYesNo, “Question”)
If Response = vbYes Then
StringToProcess = StrReverse(StringToProcess)
ActiveSheet.Cells(2, 2).Value = StringToProcess ‘Output is written to a cell adjacent to the intput
Should our Excel user have selected the ‘No’ value then the code would not have executed.