title: Detect ComboBox Change Excel VBA
body: <p>I have a sheet with a bunch of ComboBoxes(form control) and I want to detect when a user changes any one of them and write text in a cell. Using Worksheet_Change on the target cells doesn't work. I have tried a bunch of things that don't work. I'm not sure what needs to be in the private sub line or the if statement.</p>
  
  <pre><code>Private Sub DropDowns_DropButtonClick()
  If ActiveSheet.DropDowns.Value &gt; 1 Then
      Cells(13, 5).Font.Bold = True
      Cells(13, 5).Font.Color = vbRed
      Cells(13, 5).Value = "!!! Selections have been changed. !!!"
  End If
  End Sub
  </code></pre>
  
  <p>I have tried </p>
  
  <pre><code>ComboBox_AfterUpdate()
  </code></pre>
  
  <pre><code>ComboBox_Change()
  </code></pre>
  
  <pre><code>DropDowns_AfterUpdate()
  </code></pre>
  
  <pre><code>DropsDowns_Change()
  </code></pre>
  
  <p>and anything else I could find. I've also tried a few different things in the if statement with no luck. </p>
  
  <p>I appreciate any help.</p>
  
  <p>Chris</p>