Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need help in Combo box

  Asked By: Linda    Date: Nov 13    Category: MS Office    Views: 887
  

This is my first mail. 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: Alexis Castillo     Answered On: Nov 13

You would need to use the change event of the first combo  box to set the
RowSource of the second combo box.

How you would do this depends on the way your data is organised and where it
is located.

You might need to use a filter on the data to select  the relevant data rows.

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




Tagged: