Forum Discussion
Auto complete text in a drop down list cell
Hi everyone, Trying to do a spreadsheet and figured out how to make the drop down list box (yay). But I would like to have the option of auto completion of words when I type a few letters in...
Excel doesn't allows the drop down to Autocomplete, generally we use for Data Validation.
Therefore you have to work with Combo box, is one of the Active X controls.
Please check this link,,, I've shown how to do it all about Autocomplete.
Rajesh_Sinha I followed along well until it said "reach to linked cell ..." sorry.
I have my Data on one sheet, and the form on the other. How do I link it from sheet 3 (data) to be on the combo box on sheet 1?
Or no no?
- Have you tried with VLOOKUP, or even better, XLOOKUP to link different sheets? They worked great for me. Good luck with that 🙂
- The link I've show with my post has solution,,,, and it's properly elaborated,, unable to realize that where U got stuck,,, if possible better share the Workbook with me and let me examine it to Fix.
