I don't open attachments or download files.

But I put a list of stuff on Sheet2 in A1:C10.

I added a combobox from the control toolbar to sheet1.

While still in design mode, I rightclicked on the combobox and selected
properties.

Look for ColumnCount. I used 3.
(you may want to play around with the ColumnWidths property later)

Look for LinkedCell. I typed in: A1 (on sheet1)

Look for ListFillRange. I typed in: sheet2!a1:c10

Then in B1, I used this formula:
=IF(A1="","",VLOOKUP(A1,Sheet2!A1:C10,2,FALSE))
In C1:
=IF(A1="","",VLOOKUP(A1,Sheet2!A1:C10,3,FALSE))

Notice the =vlookup() range is the same as the ListFillRange.

And one more property to change:
look for: Style. I used fmStyleDropDownList
That means I can't type something in that isn't on the list.

After you get the basics running, take a closer look at all those properties.
(Save your workbook before you break anything, though!)

Tom wrote:

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

--

Dave Peterson