Consulting | Excel Examples
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.