Answer Message Box - Other than Y/N?
On 24 Mag, 18:01, SteAXA wrote:
MsgBox(prompt[, buttons] [, title] [, helpfile, context])
In buttons you can use VbYesNoCancel
if user select:
yes msgbox return vbYes (=6),
no msgbox return vbNo (=7),
cancel msgnox return vbCancel (=2).
Ste'
Like this ?
Dim reply As VbMsgBoxResult
reply = MsgBox("Yes = Copy data in Sheet1" & _
vbNewLine & _
"No = Copy data in Sheet2" & _
vbNewLine & _
" otherwise Cancel", _
vbYesNoCancel)
Ciao
:-8)
|