By 'multi-element' do you mean 'more than one column'? If so, the
answers you require a

1) MsForms.ComboBox

2) MsForms.ListBox

3) No data grid ActiveX control ships with Excel, AFAIK. Someone once
suggested here that an Excel worksheet makes an idea grid...

--

"Martin SChukrazy" wrote in message ...
Hello
I am pretty new to VBA and would appreciate some help...

1) I want to know if the standard controls that come along with Excel 2000 /
2002 professional allow for drop down lists with multi-elements sourced from
a database ?
2) Are there are also similar multi-element listboxes.

for e.g. Category Table has category ID, Category Name, DateCreated,
DateModified, Weight, FlagActivated.

I want the dropdown box to display CategoryName and weight, sourced from
the database. Same applies to the list box.
Can i do this with the standard controls..

3) The user also has a requirement for displaying detailed information (more
like a summary). The requirement is to use some form of grid. The data
source is a consolidation of data across multiple tables. For e.g.

Category Name
Category Weight
Criterion Description
Criterion Points.
...

Summary
Total Points...

Is there a grid that will allow me to do this? Also can i use the microsoft
spreadsheet control itself within an Excel User form?

Any pointers, sources will be greatly appreciated..

Thanks
Martin