assistance filter in listbox on userform using comboboxes based on option buttons

[ABDELFATTA]

hello
i try filtering data into listbox on userform using comboboxs based option buttons and headers columns so i have this code works only for combobox 2, optionbutto2 but not work rests combobox and optionbutton how the code works when i choose button of month it suppses filtering based on col a and fill combobox then choose month and show result into listbox the same thing with the rests optionbuttons i changed the column to filter about case, month, invoice but nothing happened i hope fixing this problem

[karedog]

Maybe :

Please Login or Register  to view this content.

[ABDELFATTA]

thanks karedog yes it works but combobox1 "month" doesn't show anything

[karedog]

You are welcome.

It's seemed you use non English system language (perhaps Arabic ?), so you must change value of cell of column L with your month's name in your computer's language.

Other way, we can use the month's index (January=1, February=2, etc), so it is independent of the language of your PC, like this :

Please Login or Register  to view this content.

But using this method, the months on column L must be already sorted (January, February, etc), because the name will be completely ignored using this method.

[ABDELFATTA]

yes you're right about month's name in my computer's language i changed and really works but i no know is i understand you about the other way I made in col L the months are number 1,2,3..etc but it gives me error in this line

could not set the list property. Invalid property value error

[karedog]

No, if you use the second method, you don't need to change anything on column L, but it is also ok to change it if you want it.
Please show the complete code of your Private Sub ComboBox1_Change()

[karedog]

It's already 3:00 AM here, and I need goto sleep. I will respond later (if you haven't solve it by yourelf, or no other forum member here help you).

[ABDELFATTA]

by the way i used this January ,February and 1,2 but gives the same error

[jindon]

ABDELFATTA,
I would use CheckBoxes rather than OptionButtons.

Replace 4 OptionButtons(1 to 4) with CheckBox(1 to 4).
Filter by "AND", if you want if to filter "OR" just replace "*" with "+".

Please Login or Register  to view this content.

[karedog]

You accidentally delete one row in red color, that's why it is not working.

Please Login or Register  to view this content.

By the way, if you want to display the months on column L, autoupdate with your local language, you can put this formula on L1:L12

Please Login or Register  to view this content.

[ABDELFATTA]

well done ! jindon your code is better what i have but i have something i added code in Private Sub UserForm_Initialize()
Set f = Sheets("sheet1")

to show total col 6 in textbox it doesn't change when i choose another check box cloud you help me about this

[ABDELFATTA]

thanks karedog ,I have last request if is possible I added this code

to show total in textbox1 it works only wen i run the userform but when i choose in combobox after check optionbutton it gives me error

could not set the list property. Invalid property value error

[jindon]

Change to

Please Login or Register  to view this content.

[karedog]

You are welcome, you question has been answered by jindon nicely.

Regards

[ABDELFATTA]

thanks jindon & karedog for your solution nd assistance