title: Combo box populated successfully yesterday but failed today
body: <p>I used a simple code to populate combo box from a list of worksheets dynamically. On Sat, the combo box was successfully populated. </p>
  
  <p>On Sunday I played with the code by adding new form controls/new codes. Then suddenly the combo box population just stopped to populate values and there was no error message at all.</p>
  
  <p>So I closed that workbook, rebooted the laptop, and started a new workbook with the very simple code that I got successful result on Sat.  Still, it's not working and it doesn't give me any error message.</p>
  
  <p>Then, I tried the code on another laptop with a new excel workbook. On another laptop, the combo box is successfully populated with the values I want.</p>
  
  <p>What's going on with my 1st laptop?  What can I do to make the combo box population work again?</p>
  
  <p>The code is written in worksheet/Activate environment. Here is the code: </p>
  
  <pre class="lang-vb prettyprint-override"><code>Option Explicit
  
  Private Sub Worksheet_Activate()
  
      Dim sh6 As Worksheet
  
      For Each sh6 In ThisWorkbook.Worksheets
          Me.Test2_cbbox.AddItem sh6.name
      Next sh6
  
  End Sub
  </code></pre>