[VBA]Updating a procedure or function

Intro

Managing a workbook,provided that only the standard functions of the spreadsheet are available,is a very difficult process.

Solution

The logical step is to make use of Visual Basic Applications (VBA).

Here is a brief explanation,on how to access these features.

To manage your custom procedures and functions, you must run the Visual Basic Editor:
Go to the menu Tools/Macro/Visual Basic Editor
Or simply use the combination of Alt + F11 keys simultaneously.

You should get the VBA Project window, if it is not present, open it with the View/Project Explorer or simply press Alt + r.

In this window, you'll see your workbook and opening it you should have:
Microsoft Excel Objects including:
one line per spreadsheet(to include procedures of the sheet).

• A ThisWorkbook for workbook procedures.
• A sheets folder if you have create forms with the list of forms.
• A modules folder with a line established for each module.

If you use the macro recorder to record your procedure, you will find in a module with the name you assigned.

To create a module or procedure, use the Insert menu.