listbox as filtr
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 |
listbox as filtr
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 |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com