VBA -searching using range of values

Hi i will appreciate any help rendered!

scenario:
I have a value X in cell B5 and a Value Y in cell B6, in multiple worksheets
In my userform, i have 2 comboboxes
one holding value ranges for the x coordinaate (eg 0-10, 11-20,21-30)
the other holding values for the y coordinate (eg 0-10, 11-20,21-30)

i want the user to be able to select a range from the x coordinate and the y coordinate...then i want to search thru all the B5 n B6 cels across the worksheets and return those worksheets that match the users input...

is it possible for this to be done?

It looks to me like you are looking for something like this:

Please Login or Register  to view this content.

Maybe like this:

Please Login or Register  to view this content.

It doesn't have any error checking ...

hg-could u please explain what the code is doing?

It extracts the portions of the string before and after the hyphen and converts each to a Double.

also how do i get the code to read the users selection from the combobox values?

You don't. You pass those as parameters.

Please Login or Register  to view this content.

You're welcome. Would you please mark the thread as Solved? (See How To ... in the menu bar.)