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...

Return the cells referenced by user using RefEdit control of userform in Microsoft Excel

In this article, we will show how to add RefEdit control in userform and refer cell range using it. In this example, we have created a highlighter us...

Prevent a userform from closing when the user clicks the x-button by using VBA in Microsoft Excel

In this article, we will show how to disable the x-button on the userform by using VBA. In this example, we have created a userform which can be acti...

Fill a List Box with unique values from a worksheet using VBA in Microsoft Excel

In this article, we will create a List Box in userform and load it with values after removing duplicate values. Raw data which we will insert in the ...

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