title: Excel VBA, Data Validation List. List Properties
body: <p>I want add to created DataValidation DropDownList two additional things. First is to set number of rows in DropDownList to specific number, like it is possible to do with normal combolist in VBA by ".ListRows = 11". Second is to autocomplete text typed by user (MatchEntry in combolist) to the cell based positions from DropDownList if he start typing it manually instead of choosing from list. I see that I cannot do it from position in <a href="https://msdn.microsoft.com/en-us/vba/excel-vba/articles/validation-add-method-excel" rel="nofollow noreferrer">Validation.Add Method (Excel)</a> and I do not know enough about code construction how can I do it, or how can I referee to created list by VBA code. </p>
  
  <pre><code>With Range("F26:H26").Validation
      .Delete
          .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
          Operator:=xlBetween, Formula1:="=RootCauses!A1:A11"
      .IgnoreBlank = True
      .InCellDropdown = True
      .InputTitle = varValTitle
      .ErrorTitle = varValErrTitle
      .InputMessage = varValMessage
      .ErrorMessage = varValErrMessgae
      .ShowInput = True
      .ShowError = True
      .ListRows = 11 '← my first broken solution
      .MatchEntry = 1 '← my second broken solution
  End With
  </code></pre>