title: Make the list drop down using VBA (data validation)
body: <p>I want a cell to <strong>drop down</strong> its data validation list. I do NOT want to "create a drop-down data validation list". I already have the list, I simply want it to drop down using VBA. </p>
  
  <p>Is there any way to do this?</p>
  
  <p>Example:
  If I put data in cell A1, I want cell B1 to be selected and its data validation list should drop down. I already have the code for selecting cell B1 if cell A1 has any values, but I haven't figured out how to make the cell's list drop down. </p>
  
  <p>Example code:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      With Sh1
          ' If row 1 in active column has a "1" in it, 
          ' we want to select the column to the right and drop down its list
          If .Cells(1, Target.Column).Value = 1 And Target.Value &lt;&gt; "" Then
              Target.Offset(0, 1).Select
              ' Code for dropping down the cell's list
          End If
      End With
  End Sub
  </code></pre>