[VBA] Userform Combobox filters prices in a form of price range

Hi all!

I have an excel file where in it can filter 7 out of 9 columns. My problem is that I have many prices in one column and what I want to do is when the user wants to filter it by price ranges the following price ranges will be seen in the combobox and when that price range is clicked, only the prices in that range will be seen.

the price ranges are:
"Contact Seller For Price"
"0-200k"
"201k-500k"
"501k-1M"
"1M-2M"
"2M-5M"
"5M-10M"
"10M-20M"
"20M-40M"
"40M-50M"

I happened to know the logic but then the problem is that I don't know how to make it into a code. Could you possibly help me doing this one?

Thanks!

Please see attached file.
Attachment 336746

Filter-ListBox.xls

Hi You may find the attached code useful. It came from another helpful website. The logic is there just take what you need.

All the best

Dave

Originally Posted by djm601

Attachment 336790

Hi You may find the attached code useful. It came from another helpful website. The logic is there just take what you need.

All the best

Dave

Originally Posted by nathansav

Hi,

Record yourself filtering a few as a macro, then look at the code, this will help you understand what is going on and tweak the code for your needs.

Thanks for the both of you for giving me an idea!

Nathansav,
I've tried recording and I seem to follow the code, the only problem I have is how to incorporate tha macro code in my existing code.

djm601,
Thanks for the file! I'll try to read, understand and analyze the file you gave me and maybe I could get ideas with regard to the file and my file.


Thanks so much!

Originally Posted by shg

Why not instead just add a column for price range and use a formula? Then you can filter directly in the table.

	A	B	C
1	Offer Type	Price (BDT)	Range
2	Buy	9,343,800	5M-10M
3	Buy	13,410,000	10M-20M
4	Buy	Contact seller for price	Contact seller for price
5	Buy	Contact seller for price	Contact seller for price
6	Rent	Contact seller for price	Contact seller for price

C2: =IFERROR(LOOKUP(B2, {0;201;501;1000;2000;5000;10000;20000;40000}*1000, {"0-200k";"201k-500k";"501k-1M";"1M-2M";"2M-5M";"5M-10M";"10M-20M";"20M-40M";"40M-50M"}), B2)

oh .. the problem is that I'd like to use a userform because this'll be plugged-in into a website and also this'll be a large internal database that's why it's more accurate to use a userform for this I think. The file will have 60,000 records.