Mark,

You need to filter (suggest on a worksheet somewhere), and then point the
listbox at that filter data.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
Hi,

I have problem with listbox, now.
I'd like show in userform.listbox all records in worksheet
(range(a4:h2000)) fulfil a condition: show all records
with "apple" in column(2) and fit all (8) columns in
listbox. Column(2) contain different fruit.


Can someone give me some suggestions?

Regards
Mark