Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need help in Combo box

  Asked By: Charlie    Date: Aug 27    Category: MS Office    Views: 773
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Casey Montgomery     Answered On: Aug 27

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.

 
Didn't find what you were looking for? Find more on Need help in Combo box Or get search suggestion and latest updates.




Tagged: