Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are the functions defined in MS Excel but not listed in function's guide ? and is it possible to customize a function through Microsoft VBA ?

I believe that I've seen a function which is not listed in help guide of MS excel nor in function library ; such as Fx: DateDif

is there any other functions that are not listed ?

As well (this question for Macros specialists) , is it possible to build a customized function through Visual basic for applications (VBA) 

Macro Microsoft Excel
user-image
Question ajoutée par Hassan Mohsen Ibrahim , advisor , ministry of tourism
Date de publication: 2018/04/08
Apprécier (0) Vues (12) Suiveurs (3) Réponses (3) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

there are some functions that are not listed in the functions list like: DateDif(), which Microsoft tries to hide as they provide more flexible functions.

yes, you can build a custom function in VBA and use it in your sheets.

Moreover, you can build and Add-in to use it in all your workbooks.

 

Thank you for the question

 

kashaf farooq
par kashaf farooq , superwisear , lacarne meat shop in csd

it a programming instructions stored, a code that can be used to eliminate the need tasks over and over again or its a looping tasks.

Muhammad Jamil Akhtar
par Muhammad Jamil Akhtar , Principal , Education Deptt. Govt. of the Punjab. Pakistan

This function generates and expresses most of the written work .....

Ecrivez Votre Réponse
More Questions Like This