Raise Error from ActiveX dll to VBA
 

Ok I am trying to raise my own error upto VBA function from my VB dll like
this:

Err.Number = vbobjecterror + 100
Err.Source = CalculatePL
Err.Description = "Array sizes do not match"
GoTo Err_Handler
..
..
..
Err_Handler:
Err.Raise Err.Number, Err.Source, Err.Description

But! it seems that Excel VBA uses Err.Number to show it's own Err
description, not the one I set. I tried setting Err.Number to all kinds of
values, but I was never able to show my custom description.

Is there a workaround?

Thanks

Serge