I have seen a spreadsheet that has a drop-down box (combo box). When being
clicked on, it shows data in multiple columns. When selecting a value from
any of the default values, their associated information is automatically
placed into adjacent cells.

Pls see http://www.microsheet.com/Downloads.htm and download the Time &
Expense Manager example. On the INVOICE tab, you'll see combos under Task
Description. I'm trying to built such drop-down menu.

How can I create such drop-down menu from which I select a value and a few
other columns are automatically filled?

Tom