title: Excel Form Combobox value to cell
body: <p>I have an Excel VBA Form and ComboBox that has the 12 months of the year. What I want it to do is when I select a month, it should also write that month value in a specific cell in the workbook as that cell value is linked throughout the workbook.</p>
  
  <p>My issue here is that once loaded on opening the workbook, the values do not refresh and they do not copy from the ComboBox to the cell. How can I make this work ?</p>
  
  <pre><code>Private Sub Workbook_Open()
  
      With Form1
          .Show vbModeless 
          .ComboBox1.List = ThisWorkbook.Sheets("Liste").Range("D2:D13").Value 'month lists
      End With
      ThisWorkbook.Sheets("Sheet2").Range("B2").Value = Form1.ComboBox1.Value
  End Sub
  </code></pre>