How to Create a Form for Search and Print through VBA in Microsoft Excel

In this article, we are going to learn how to create a user form for search and print through VBA in Microsoft Excel.   Let’s understand wi...

How to Add an Input Message in Data Validation

In this article, we will learn how to add an input message in data validation while entering the specific entries in the cell, using VBA in Microsoft ...

Fill a ListBox control with values from closed workbook using VBA in Microsoft Excel

In this article, we will fetch data from closed workbook to List box in userform using VBA. Raw data for this example is in range A2:B10 on “23Samp...

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

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.