title: How to make the condition dynamic within Case Statement in VBA?
body: <p>I'm working with the following code at the moment: </p>
  
  <pre><code>Sub DropDown1_Change()
      With ThisWorkbook.Sheets("Dashboard").Shapes("Drop Down 1").ControlFormat
          Select Case .List(.Value)
              Case "Region1": Region0_Select
              Case "Region2": Region1_Select
              Case "Region3": Region2_Select
          End Select
      End With
  End Sub
  </code></pre>
  
  <p>The macro relates to a dropdown on an excel sheet. </p>
  
  <p>Is there any way to base the condition on a cell value? i.e. IF the dropdown equals cell A1 instead of "Region1".</p>
  
  <p>I tried using something with Range("A1").Value to no avail. </p>