Combo Box with Ranges Lists

Is it possible to create a Combo Box that lists a series of different ranges? For example:

Column Name:	Neighborhood Population
List Item 1	1 thru 1000
List Item 2	1001 thru 2000
List Item 3	2001 thru 3000
List Item 4	3001 thru 4000
List Item 5	4001 thru 5000

and so on...

Whatever list item I choose will be the search criteria to show only those rows that meet this criteria.

Thanks in advance!

Dan

Hi Tim:

Thanks for responding so quickly.

The Combo Box will be placed in an Excel 2010 worksheet. The choices I displayed in my post would be equivalent to the items shown. For example in standard mathematics notation it would be a≤x≤b. In my examples it would be 1000≤x≤1, 2000≤x≤1001, 3000≤x≤2001, 4000≤x≤3001, 5000≤x≤4001.

Whenever any of these items in the Combo Box is selected, the entire worksheet would be condensed to show only those rows that fulfilled the selected criteria for the column titled Neighborhood Population.

My question boils down to, Is there any format that Excel will use to accomplish each range? Will the Mathematics Notation work? I think this as clear as I can explain what I want to do.

Dan

Hi sintek:

Yes it does work now. When I 1st changed the column text in column 1, 2nd sheet, it didn't work for some reason. However, when I closed the file and just reopened it, it worked just fine (probably an updating problem).

I posted a good rating for you for your fine effort.

Thanks again,

Dan

Hi Sintek:

Sorry to bother you again.

1. I want to copy the table from Sheet 2 to a blank area on Sheet 1. I then want to delete Sheet 2. I will hide the copied table on Sheet 1. I know this will affect the coding in the macro you originally submitted. Can you produce a revised macro to accommodate my change.

2. Can the Sub Auto Open() be eliminated?

3. If I decide to not use a Combo Box, but instead instead have the end user supply his own range, can that be done? What would the search criteria look like for a range of 1 o 1000, as an example?

Thanks again for your help and patience!

Dan

This is your original sample you sent to me:

https://www.excelforum.com/attachmen...lists-dan.xlsm

For some unknown reason to me, I cannot find where to attach your original attachment (so I supplied the link above). Let me know if that works for you. Maybe this will let you recall how and why you responded.

Dan

My laptop with my file in it is scheduled to be returned tomorrow from Dell repair. As soon as I have my computer back I will send you the file.

Dan