vba: on error, force function to return

Question

i have a function that returns a string

on error, i would like it to return a specific value. how do i do this?

Answer 1

Use On Error GoTo to branch to a specific label if an error occurs:

Function YourFunction() {
  On Error GoTo ErrorLabel
  ... your code ...
  Exit Function
  ErrorLabel:
    YourFunction = yourspecificvalue
}