Consulting | Excel Examples
Keywords: ListBox, Data Entry
Description: Example of Visual Basic for Applications procedure that draws a list box aligned with the active cell and inserts value selected from list box into active cell.
Tip: You can create a Visual Basic for Applications procedures that creates a new list box "on the fly" when a command button is clicked. The list box can be positioned near the active cell and the value selected copied to the activecell. When the copy is complete, the list box can be deleted from the worksheet.
Guide to the Example: Select a cell on Sheet and click on the "Pick from List" button. Choose and item from the list and it will be copied to the active cell. The "Control" sheet contains the list values used by the ShowLIst and ListClick procedures in Module1.
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.