Speedup ActiveX ListBox

I have an inventory of approximately 200 rows and 250 columns of data, including short text and numbers. There are several formulas throughout and about 20% of all cells have Comments. I am using an ActiveX ListBox to sort and hide/unhide rows based on the text entries in a single column (IG). The ListBox macro is:

Please Login or Register  to view this content.

In my spreadsheet there are actually 18 different food groups, but you get the idea...

The macro for showing all rows is:

Please Login or Register  to view this content.

It is lightning fast. Works great.

A standard macro to show rows for just one food group is:

Please Login or Register  to view this content.

Here's the problem. Selecting anything but "SHOW ALL ROWS" takes about 4-5 seconds. Is there some way I can speed this up without changing the macro to hide/unhide rows based on row #? I need to avoid this as the number of rows for each food group can change and I don't want to be constantly editing the macros to reflect that. Any ideas?

BTW, I also intend to do the same for columns, with a second ListBox. This will allow a user to quickly & accurately isolate just a few cells throughout this large sheet file. And, in case you're wondering, I'm using a ListBox rather than a ComboBox as I want to show the entire list at-a-glance, to hasten the selection process.

Thanks for your help. David

Could you be more specific, please?

Norie, I investigated the built-in filtering but I don't think it will work because there are about 10 rows of data at the top that I always need to be revealed when hiding/unhiding rows. Is there anything I can do to adjust my code below to speed it up? Otherwise, I'm stuck with hiding/unhiding rows & columns based on specific ranges. The benefit of hiding/unhiding based on matching cell content to a referenced cell is that if I add a row or column all I have to make sure is that it is populated with the correct text in the referenced row or column range. This will save me from having to edit dozens of macros if adding/deleting rows or columns. Any thoughts you have are very much appreciated. David

Hi David,
try so

Please Login or Register  to view this content.

Thanks Nilem! This works beautifully. I appreciate your help very much. David