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

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

Change the value/content of several UserForm-controls using VBA in Microsoft Excel

In an Excel 5/95 dialogsheet it is possible to change the value/content of a collection of controls by looping through the controls in the collecti...

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