Refreshing a Combo Box

[Steve C]

I have a user form with two combo boxes. In ComboBox1, the user selects a
Division from 1-16. Based on that selection, ComboBox2 is then populated with
the appropriate corresponding choices. My problem is that if the user
chooses Division 3 for example, then changes his mind and selects Division 7
(before closing the form), ComboBox2 then populates with choices for both
Division 3 and 7. Is there a command for refreshing ComboBox2 upon changing
ComboBox1 so that it only displays the selected division? Thanks.

Steve C

 

[Jay Freedman]

I have a user form with two combo boxes. In ComboBox1, the user
selects a Division from 1-16. Based on that selection, ComboBox2 is
then populated with the appropriate corresponding choices. My
problem is that if the user chooses Division 3 for example, then
changes his mind and selects Division 7 (before closing the form),
ComboBox2 then populates with choices for both Division 3 and 7. Is
there a command for refreshing ComboBox2 upon changing ComboBox1 so
that it only displays the selected division? Thanks.

Steve C

Hi Steve,

In the code (ComboBox1_Change()?) that loads items into ComboBox2, the first
statement should be

ComboBox2.Clear

That will delete all the choices currently in the list, and the code will
then start adding items to an empty list.

 

[Steve C]

Thank you, Jay! (or should I call you Obi-Wan?)

Steve C (not quite the programming jedi yet)