It can be done, but two questions.

Is the name Carl the complete value in the cells, or part, and what column
is the name in?

What do you mean by load the listbox with the records? Is that the names or
some other column?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"marmo" wrote in message
...
Hi again ,
In an earlier mail i asked about filtering a listbox.
I think i did not explain things clearly enough.
Therefor i'll try again in this post:

I have a little application in Excel with several sheets.
One of the sheets contains client data such as name (columnA), address
(columnB) , etc.....
This range is called DbClients
On a Userform i have a listbox which has the DBClients as rowsource

What i'd like to do is to put a textbox above the listbox to filter the
data
in the listbox.
When i type "Carl" in the textbox , the listbox should only show the
records
with the name "Carl"

Is there a way to do this or is it to complicated.
I'm using Excel 2000-2002
If not possible, please also reply.
If more info needed , don't hesitate to reply.

Many thanks
MarMo