Though i am not an expert,i use many VBA Macros and
designed a few.
Currently, i am designing a macro for a project. I need your help here, as i am
unable to proceed.

The scenario:
I have three combo boxes. 1 for subject name, 1 for Region and 1 for Month Name.
Now,i want to do the following.

Select the subject in first combo box. Only the coresponding regions where the
classes for that subject has been conducted should display in combo box2 and not
all regions.

Example:
Subject1 conducted in region1,region2 and region3.
Subject 2 conducted in region1.

If i select subject 1 in combobox1, then region1,2and 3 should be listed in
combo box2.
If is select subject 2, only region1 should be listed in combo box2.

Any suggesitions are welcmoe as i am running short of time to complete the
project.