title: activex controls vs forms control in excel
body: <p>I have some activex as well as forms control (drop downs for testing purpose) on my excel 2007 worksheet. I have binded the data using the code below :</p>
  
  <pre><code>Private Sub ComboBox1_Change()
      If ComboBox1.Value = 1 Then
          ComboBox2.List = Array("a", "b", "c")
          ComboBox2.Value = ComboBox2.List(0)
      ElseIf ComboBox1.Value = 2 Then
          ComboBox2.List = Array("A", "B", "C", "D")
          ComboBox2.Value = ComboBox2.List(0)        
      End If
  End Sub
  
  Private Sub Worksheet_Activate()
      ComboBox1.List = Array(1, 2)  
      ComboBox3.List = Array("Delhi", "Kolkata")
      ComboBox3.Value = ComboBox3.List(0)
      ComboBox4.List = Array("Delhi6", "Kolkata71")
      ComboBox4.Value = ComboBox4.List(0)
  End Sub
  
  Private Sub UserForm_Initialize()
      ComboBox1.List = Array(1, 2)
  End Sub
  </code></pre>
  
  <p>But when I reopen my worksheet, the comboboxes are opening in the state in which they were 
  closed and no data remains in the dropdown. Please advise as to which event I'm missing to fire??</p>
  
  <p>Thanks in advance...</p>