MsgBox questions [RESOLVED]

[bat711]

Is it possible when using a MsgBox to have a click event on the 'OK', 'Cancel' buttons or do I just need to make a new form with some command buttons?

Related to this can you put a working hyperlink in a MsgBox?

Thanks.

[manavo11]

Hyperlink? No...

To see which button was pressed you can use this :

Dim Result As VbMsgBoxResult
 
Result = MsgBox("Pick something", vbOKCancel)
 
If Result = vbOK Then
    MsgBox "OK pressed"
Else 'elseif Result=vbCancel then
    MsgBox "Cancel pressed"
End If

[bat711]

Ok, thanks.