filter and sort excel column data with combo box

[Babaand]

Dear sir,
I have to create excel student database for my school. In this I have userform and other tools on it. for this database I have religion and cast category table and three different combo boxes for this information. I have to select firstly category, in second combo regligion and lastly cast alphabatically. Pls code for vba code
I am sending u sample file
Pls guide me
Thank u in advanse


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

Babaand ... hmmm
Would You try to the first filter with those three parameters and
after that sort with same three parameters ... or how?

 

[Babaand]

Dear sir,
Thank you for answering...
I have to filter firstly category, then out of category the religion will be selected.
e.g. i have selected obc category with cbocat then Hindu and Muslim these two option should be displayed in religion combo box, at last if I selected Hindu religion then all categories from Hindu religion should be displayed in cbocast combo box alphabetically.

Pls help

Thanking you again

 

[vletm]

Babaand ... like these steps in sheet?

Where do You need that UserForm?
What will You do next?

 

[Babaand]

I have added userform in this file which will found in VBA
Pls provide me VBA code also

 

[vletm]

Babaand
My keywords were:
Where ...
What ...

 

[Babaand]

Dear sir
Thanks for your interest in answering...
I have to filter the data like this screen shot. So I have inserted userform in vba console and I have to filter data with help of combo box for sutdent data Entry

Pls guide with VBA code
Thanking you

 

[vletm]

Babaand
... checking
... my keywords?
... ideas?

 

[Babaand]

Very Good
But the code works only one time
at first start the code works but for next record or reopening of form it does not works

 

[vletm]

Babaand
I'm understanding the 1st line.
It was midnight and I missed one part of the last code of selection.
Now, even the casts selection will show the result.
It is not 99% ready but it works as You wrote
... then You'll open the file!
If You cannot tell more details ...
It will be a challenge.