Скачать с ютуб Basics of VBA functions procedure в хорошем качестве

Basics of VBA functions procedure

Function procedure. In procedure we have two types of procedure. First one is subroutine and second one is function. So mainly functions used to perform some calculation and returns one value and it's syntax of function is the same as subroutine and the scope also its like a private and public. Entire syntax is the same as we used in sub procedure. Difference between subroutine and function: The main difference is procedure doesn't return any value however the function return value and Second difference I can say some procedure perform an action for example manipulate the data and one function work on calculation part and it will not manipulate the data and it will return value. With Private ,You can't use this one in formula that is the basic basic fundamental behind to create the function as a private. How to execute the function: Function can't run directly we can call a function from one sub procedure/subroutine so that is the one way and we can use that particular function in my work sheet formula also if I have not declared as a private.