Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate wind
Hi,
It is not a function; it is a constant. If you lookup msgbox function and
msgbox constants in Help you will find out more about it. The following is a
small example of its use where the users selection is returned to a variable.
Sub test()
Dim Response As Variant
Response = MsgBox("Do you want to continue?", vbOKCancel)
If Response = vbOK Then
MsgBox "User selected OK"
'Insert required code here
Else
MsgBox "User cancelled." & vbLf & _
"Processing terminated."
End If
End Sub
--
Regards,
OssieMac
"G Lykos" wrote:
Thanks!
George
.
|