As you are talking about proto-typing a relational database, maybe the
best is to use SQL.

RBS


"Bart Wouters" wrote in message
...
I just noticed posting this message in the wrong discussiongroup *sorry*
...
so here it is in the correc place)

Hi all,

I am currently doing some rapid prototyping in VBA-Excel2003.
Excel is used as lightweight relational database, hence requiring
frequent selection of 'records/rows' based on multiple criteria.

The selections then are transformed into arrays in order to present them
in
listboxes.

What is the most efficient/performant way to filter out the relevant
information ?
autofilter ? advancefilter ? find(next) ? for each r in rows - loop ?

tnx in advance,
kind regards,
Bart Wouters