Consulting | Excel Examples

Custom Dialog and List Box

Keywords: List Box, VLOOKUP, Command Button, Dialog Sheet

Description: Create a custom dialog to select items from a master list and enter a value in a worksheet cell.

Tip: You can use a simple Visual Basic for Applications procedure to display a custom dialog and list box. If you use worksheet ranges to control the list box, it is easy to return the selected value to a location on your worksheet. With only 12 lines of Visual Basic for Applications code, you can build a useful lookup feature

Guide to the Example: Select a blank cell in column A of the "Demonstration" worksheet. Click on the "Insert Sales Value" button and pick an item from the sales catalog. The name of the item will be returned to the cell you selected and its price to the cell in Column B.

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