• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Type for Autocomplete


I am working on a form and running into a brick wall. For my contacts, I would like to have autocomplete options to make their process more efficient. For example, in Non Labor BPW! C7:C1810 would complete as they type. The validation is off the array in Controls! that starts in $J$2#. The same concept with in Non Labor BPW! D7:D1810 against Controls! $L$2#.

Not sure if this would ultimately work better with VBA or not but I have been running into issues getting this together. Any help would be greatly appreciated. Thanks!



Active Member
One method which doesn't require VBA would be the utilization of the first X number of rows for permanent storage
of common terms to be used. As you may already know, Excel has built-in auto recall of previously entered terms. So
as you type on subsequent rows below, the suggested terms auto display for acceptance or not.