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 I want add to created DataValidation DropDownLi