Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Hassan Mohsen Ibrahim , advisor , ministry of tourism
Date Posted: 2018/04/08
Upvote (0) Views (12) Followers (3) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by 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
by 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
by Muhammad Jamil Akhtar , Principal , Education Deptt. Govt. of the Punjab. Pakistan

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

Write Your Answer
More Questions Like This