阅读背景:

Excel VBA,数据验证列表。列表属性

来源:互联网 

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




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: