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 ?

Question

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)

Firas Shahadi · Answer

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 · Answer

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 · Answer

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

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

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 ?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة