Excel - User Defined Functions

October 2016

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 :

This document entitled « Excel - User Defined Functions » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.