Consulting | Excel Examples

List Box Lookup

Keywords: List Box, Lookup, Dialog Sheet, Edit Box

Description: Select items from a List Box by entering the first few characters of the item’s name. The first matching item in the List Box is automatically highlighted.

Tip: You can look up entries in a list box by entering the first few letters of the entry in an edit box. With a Visual Basic for Applications procedure, the matching entry in the list box will be highlighted. When you change the text in the edit box, the list box will scroll and change its selection value

Guide to the Example: Click on the "Demonstration" button on the List Box Lookup Demonstration sheet.The dialog, control and module sheets are hidden. To view them, select Format / Sheets / UnHide. Try adding your own entries to the list box contents range on the control sheet.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

 

Last modified: May 21, 1996