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.