We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
10 years ago
Solved

Filter UserForm ComboBox based on previous ComboBox selection

Hi… I have question regarding the use of ComboBoxes on a UserForm in a Keyword test. I have a “Department” ComboBox that is populated with the following…  “Dariy”, “Frozen”, “Grocery”…etc.  I would ...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    10 years ago

    Add the Clear method at the beginning of the OnChange event handler to clear the list of Warehouse combobox. Here is my code:

    function UserForm1_cxComboBox2_OnChange(Sender)
{
  UserForms.UserForm1.cxComboBox1.Properties.Items.Clear();
  if (UserForms.UserForm1.cxComboBox2.Text == "Frozen")
   {   
      with (UserForms.UserForm1.cxComboBox1.Properties.Items)
    {
      Add("100-Warehouse 100");
      Add("200-Warehouse 200");
    }
    }
  if (UserForms.UserForm1.cxComboBox2.Text == "Dairy")
   {   
      with (UserForms.UserForm1.cxComboBox1.Properties.Items)
    {
      Add("110-Warehouse 110");
      Add("210-Warehouse 210");
    }
    }
}

    Does it help?

     

DCat1223's avatar
DCat1223
Frequent Contributor
10 years ago

Hi Tanya...  Thank you for your help.  I'm getting closer. 

Regardless of the department I select in the dropdown, all warehouses display.  Code and screenshot attached. 

 

Again, what am I missing here?  Unfortunately I'm not a developer so coding is trial and error for me.  I suspect the issue lies in the IF statement but I'm certain. 

 

Again, thank you so much for your assistance.

 

 

TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
10 years ago

Add the Clear method at the beginning of the OnChange event handler to clear the list of Warehouse combobox. Here is my code:

function UserForm1_cxComboBox2_OnChange(Sender)
{
  UserForms.UserForm1.cxComboBox1.Properties.Items.Clear();
  if (UserForms.UserForm1.cxComboBox2.Text == "Frozen")
   {   
      with (UserForms.UserForm1.cxComboBox1.Properties.Items)
    {
      Add("100-Warehouse 100");
      Add("200-Warehouse 200");
    }
    }
  if (UserForms.UserForm1.cxComboBox2.Text == "Dairy")
   {   
      with (UserForms.UserForm1.cxComboBox1.Properties.Items)
    {
      Add("110-Warehouse 110");
      Add("210-Warehouse 210");
    }
    }
}

Does it help?

 

  • DCat1223's avatar
    DCat1223
    Frequent Contributor
    10 years ago

    That did it.  Thank you again Tanya.  I really appreciate your assistance!

    • TanyaYatskovska's avatar
      TanyaYatskovska
      Icon for Alumni rankAlumni
      10 years ago

      You are welcome :)