Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
how to display error message?
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! |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
how to display error message?
hi
not sure if i'm uderstanding correctly but if a cell is displaying #NUM!, that is the error. what is the fomula that is generating the error. see this site for a explination of excel formula errors. http://www.dummies.com/WileyCDA/Dumm...FFICESOFT.html regards FSt1 "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! |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
how to display error message?
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel must display error message if two blocks don't have same num | Excel Worksheet Functions | |||
how to display an error message | Excel Worksheet Functions | |||
Why error message when trying to display custom view? | Excel Discussion (Misc queries) | |||
Why error message - not enough system resources to display comple. | Excel Discussion (Misc queries) | |||
How to display a blank cell with no error message | Excel Worksheet Functions |