Autofill or auto suggest in textbox

dwarek

Board Regular
Joined
Jul 15, 2016
Messages
77
Hello everyone i have created a userform AND now the issue is i need a code TO autofill or autosuggest text in the textbox, for example if i have already entered text 'JOHN' and next time if i type J it should suggest me JOHN. is there any vba code for that pls help me as i need to submit my project in my office asap. thanks in advance
 
Last edited:

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
There sort of is but its a little complex. You will have to use a combobox that is filled by means of a named range. If its a simple case that you will never need any other names in this named range its simple. If not you need to allow the combobox to receive answers that are not in the named range plus then you need to add to your named range to include the new answer for future use. That probably makes no sense!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,789
Messages
5,470,791
Members
406,724
Latest member
BruceLee Nguyen

This Week's Hot Topics

Top