RE: how to display error message?

Giganews Newsgroups
Subject: RE: how to display error message?
Posted by:  JLGWhiz
Date: Sun, 6 Jul 2008

Is this what you are looking for?
Sub ErrorOut()
'Code that errors
On Error GoTo Handler:
'Other code
Exit Sub
Handler:
  ErrMsg = Error(Err.Number)
  MsgBox "Error Is: " & ErrMsg
End Sub

"LunaMoon" wrote:

> Hi all,
>
> I am using VC++ to develop some XLL file for use in Excel 2003.
>
> Of course there are bugs.
>
> The cell display "#NUM!".
>
> But in VC++ I've already thrown exception with error message:
>
> if (a!=b)
>    throw Constructor ("a must be equal b.", "myclass")...
>
> Why couldn't I see the error message in Excel?
>
> Thanks!

Replies

None

In response to

how to display error message? posted by LunaMoon on Sun, 6 Jul 2008