MsgBox Options

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

what is the correct way to display an information type message box with
below criteria? i went by the help example, but get syntax error. also, i
don't want to offer a help file.

example:

msgbox ("Data Imported",vbInformation,"Import",0,0)
 
Hi Scott

The problem is the parentheses. You should only use them when you are
calling MsgBox as a function, to receive a returned value. Also, the last
two arguments are optional, so if you want no Help button you should omit
them completely.

Either:
MsgBox "Data Imported",vbInformation,"Import"
or
Call MsgBox ("Data Imported",vbInformation,"Import")
 
Back
Top