title: Excel VBA - Manual input of data in data validation cell
body: <p>I have  worksheet which has various validation lists, however for all these lists I need to have the option of users own entry in the cell. </p>
  
  <p>I know you can uncheck the box however because my worksheet gets regenerated on a regular basis I need to achieve this programatically. Anyone have any idea how to do this? Here is the code I have that creates the drop down lists:</p>
  
  <pre><code>    For u = 1 To SpecDependencies.count
          SpecDepList = SpecDepList &amp; "," &amp; SpecDependencies(u) &amp; " - " &amp; SpecDepDate(u)
      Next
  
      With CRC.Cells(ECURowInCRC, 8).Validation
          .Delete
          .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
              xlBetween, Formula1:=SpecDepList
          .IgnoreBlank = True
          .InCellDropdown = True
          .InputMessage = "View Spec Dependancies"
          '.ErrorMessage = "No value selected"
          .ShowInput = True
          '.ShowError = True
      End With
  
      End If
  
      SpecDepList = ""
      Set SpecDependencies = New Collection
      Set SpecDepDate = New Collection
  </code></pre>