VBA - Updating a procedure or function

October 2016

Managing a workbook using only the standard functions of the spreadsheet may be problematic. To manage your procedures and custom functions, you can use the Visual Basic Editor: Go to Tools > Macro > Visual Basic Editor or press Alt + F11 simultaneously.

The following window "Project - VBAProject" shall be displayed, if it is not present, go to View > Project Explorer or simply press Alt + R.
In this window, you will see your file and you can expand its tree as explained below:
  • the "Microsoft Excel Objects" folder including:
    • one a line for each worksheet - for specific procedures of each sheet.
    • the "ThisWorkbook" line, for procedures workbook.
  • the "Sheet" folder, if you have created forms, with the list of forms.
  • the "Modules" folder, for one line created for each module.

If you used the macro recorder to record your procedure, you will find it in a module (with the name you gave it).
  • If you want to introduce a procedure from an online source or forum, double click on the appropriate line and paste the it.
  • To create a module or a procedure, use the Insert menu.
  • A custom function must be created in a standard Module in order to be called from a sheet.

Related :

This document entitled « VBA - Updating a procedure or function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.