"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 ?
Not directly. Excel can source a drop-down from a range on a worksheet, but
not a database. To do this you would need tgo colde it to either pull from
the database and load the drop-down, or pull from a database, load onto a
worksheet range, and link to that range. Clearly, there is no dynamic
element i n this such that if the database changes, other that what you as
the programmer builds in.
2) Are there are also similar multi-element listboxes.
for e.g. Category Table has category ID, Category Name, DateCreated,
DateModified, Weight, FlagActivated.
Do you mean that if a category is selected from DD#1, then DD#2 will be
loaded with the categories associated with that id, and it it changes then
DD#2 also changes? If so, then no, this is again not automatic and needs to
be coded.
If you mean seeing the multiple columns in the DD, then this is posisble
with a control toolbar dropdown (don't know about forms DD, don't use them).
In this scenario, you set the ColumnCount property to the number of columns,
and direct the ListFillrange property to the multiple column worksheet data
range. To get the data, this is an example click event that displays the
first and second column
Private Sub ComboBox1_Change()
With ComboBox1
MsgBox .Value & .List(.ListIndex, 1)
End With
End Sub
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?
There are a number of datagrid controls around, but examples of using them
seems to be sparse. Here is a coupl of alternative approaches in a previous
post
http://tinyurl.com/35gmk