Return error values from user defined functions
With the example function below you can get user defined functions to return error values
just like the built in functions in Excel do.
Function DummyFunctionWithErrorCheck(InputValue As Variant) As Variant
If InputValue < 0 Then ' return an error value
DummyFunctionWithErrorCheck = CVErr(xlErrNA) ' retunerer #I/T!
' xlErrDiv0, xlErrNA, xlErrName, xlErrNull, xlErrNum , xlErrRef, xlErrValue
Exit Function
End If
' do the calculation
DummyFunctionWithErrorCheck = InputValue * 2
End Function
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
