Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago

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
    9 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
    9 years ago

    Thank you, Tanya.  This looks promising. 

    I am getting an error and can't seem to triage this.  Please see attached screenshot.

    What am I doing wrong here?

     

     

     

     

    • TanyaYatskovska's avatar
      TanyaYatskovska
      SmartBear Alumni (Retired)
      9 years ago

      Hi,

       

      You need to call Add inside with. The with operator allows you to define an object where Add will belong. Take a look at your script where you fill in the combobox based on Dairy.

       

      • DCat1223's avatar
        DCat1223
        Frequent Contributor
        9 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.