title: Excel ActiveX Combo Box not Showing Selection
body: <p>I'm using a ActiveX Combo Box to show all or some Worksheets. In addition to that, on the same worksheet I have some Form Controls Check Boxes where the user can use them as filters for the Combo Box. So for instance, each check box have the name of department and so when one is checked the list will be updated with the worksheets related to that name. Which works fine.</p>
  <p>However, the problem I have is that if I do choose an option from the Combo Box drop down list, it doesn't come up on the field of the Combo Box.</p>
  <p>Here is the code I'm using at the moment.</p>
  <pre><code>Private Sub TransferList_DropButtonClick()
      Application.EnableEvents = False
      Dim ws As Worksheet
  
      I = 1
      TransferList.Clear
      For Each ws In Sheets
          If ActiveSheet.Shapes(&quot;CheckBox_Viva&quot;).ControlFormat.Value = 1 Then
              TransferList.AddItem ws.Name
              I = I + 1
          End If
      Next ws
      
      Application.EnableEvents = True
  
  End Sub
  </code></pre>
  <p>I did some research and I did find that by using the <code>TransferList_Change</code> the issue is resolved but the filtering is not working (no change whether a check box is <code>True</code> or <code>False</code>).</p>
  <p>What am I missing?</p>
  <p>Cheers.</p>