How to get button clicked value from system generated error message in Excel vba

[sxschech]

Maybe not using the right search terms, was wondering how to get what the user clicked on when a system error message happens or do I need to build my own message box and trap for the error. Since the system generated message gives the user the option of yes, no or cancel, I thought I could get the value of what they clicked on without having to write out a message box and error handling. Intellisense only seems to get the error number and message, didn't see an option for getting vbyes, vbno or vbcancel.

 

[SkipVought]

Hi,

You'll get better results posting in forum707.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[sxschech]

Ok, will repost there. Thought since it was excel rather than access to post here, but guess that vba is the determining factor.

 

[SkipVought]

Access VBA has its own forum. Forum707 is for VBA for every other MS Application, including Excel.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]