Delete a procedure from a module using VBA in Microsoft Excel

  In this article, we will create a macro to delete another macro from a module. We are using Module1, which contains SampleProcedure as the sa...

Delete a module using VBA in Microsoft Excel

  In this article we will create a macro to delete module from the workbook. We will be using the MainModule as raw module. We want to get r...

Create a new module using VBA in Microsoft Excel

In this article, we will create a macro to insert a new module in an Excel workbook. Before running the macro, we need to specify the type and name o...

Copy modules from one workbook to another using VBA in Microsoft Excel

With the macro below you can copy modules from one workbook to anaother: Sub CopyModule(SourceWB As Workbook, strModuleName As String, _ TargetW...

How to create a form in Microsoft Excel

The Course Booking Form is a simple form illustrating the principles of UserForm design and the associated VBA coding. It uses a selection of contr...

Add content to a module from a file using VBA in Microsoft Excel

If you don't want to add a complete module, you can add just the missing procedures to an existing module by using the macro below. It adds the conte...

Add a procedure to a module using VBA in Microsoft Excel

You can add code to a module without using a separate text file that contains the code. The macro below shows how this can be done. The macro must be...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube