Excel - User Defined Functions

February 2017


If the complement you are installing contain additional functions, the features are available in the user defined category of the Insert dialog box of a function.

CALLING FUNCTIONCalls a procedure in a dynamic link library or code resource.
EUROCONVERTConverts a number to Euros, converts a number in Euros to the currency of another European..
REGISTER.ID FUNCTIONReturns the identification number of the Registry (dynamic link library) that was specified or code resource that has been previously set into the registry.
SQL.REQUESTConnects to an external data source, executes a query from a worksheet, then returns the result as an array without the need to program a macro.




Related


Published by deri58. Latest update on October 10, 2012 at 06:28 AM by deri58.
This document, titled "Excel - User Defined Functions," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).