We now want to create a dynamic named range for the search results. This has been tested to work nicely with the data used. The ColumnWidths have been set to 20pt, 200pt and 80pt. This will show the first row above the row source selection as headers. This is because we want to show 3 columns of information in the ListBox (ID, Product Name and Quantity Per Unit) The Name is changed to lstSearchResults so that it is easy to reference when writing the VBA code. With the ListBox inserted, we shall change some important properties in the Properties Window (if you do not see this, click View > Properties Window). This is done to keep this tutorial shorter and to the point.Ĭlick on the ListBox control button and draw it onto the userform. This tutorial is assuming that the other parts of the userform (text box and buttons) have already been created. The first task is the insert the ListBox control and to set some key properties for it. You can also read on to see the VBA code and techniques used. This video tutorial will take you through the entire process. Then our VBA code will return the search results to the ListBox, and add the product they select to the form on the spreadsheet. This opens the form below, where they can enter keywords to search for the product they need. If so, they can click on the Advanced Search button. Sometimes though, the user does not know the product ID. The user enters the ID of a product, and VLOOKUP formulas return the related information from a product list into the other columns. A search result can then be selected and added to a row on a spreadsheet. We want a user to type into a text box, and the search results of that entry to appear in a ListBox. In this blog post we will look at showing search results in a ListBox of a userform in Excel VBA.

Excel vba userform listbox