Need a decent custom made IFError Function in VBA

[JakeVBA2009]

Can someone please help me by creating a decent IFError Function in VBA that closely mimics the Excel 2007 IFERROR Function?

I've tried a few pieces of code which just arent good enough and I need someone to work some magic.

Thanks.

 

[mikerickson]

I'm not positive about the number and order of the arguments of Excel's IFERROR, but I think that this will work.

Function MyIfError(testValue As Variant, errorValue As Variant) As Variant
    MyIfError = testValue
    If IsError(testValue) Then MyIfError = errorValue
End Function