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

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