text: i want to add auto complete feature to excel vba text box help pl?   excel does it automatically for a drop down list or comboxbox. i would suggest you use those two instead of a text box. to make it work in a textbox, you would have to do some coding.