Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel UDF to return errors as Excel does (Read 1971 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel UDF to return errors as Excel does
15.10.09 at 08:24:52
 
Excel UDF to return errors as Excel does
 
To return error values in user defined functions (UDF's) in Excel you can use the CVErr function passing the number of the error to display.  
 
Example: to display a #Value error you can use the following code
 
Public Function MyError as Variant
  MyError = CVErr(xlErrValue)
End Function
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1