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

Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel

If you want to get any information from the user you can use the INPUTBOX-function. This function displays a dialogbox that lets the user fill inn an...

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.