title: Excel VBA: IF ComboBox.Value statement
body: <p>Hi I have this ComboBox and I would like to do some command if the combox value says for example Paris</p>
  
  <pre><code>Private Sub Workbook_open()
  
  With Sheet1.ComboBox1
  .AddItem "Paris"
  .AddItem "New York"
  .AddItem "London"
  End With
  
  If Me.ComboBox1.Value = "Paris" Then
  Range("A1").Value = 5
  End If
  
  End Sub
  </code></pre>
  
  <p>Any help?
  Thank you</p>