Autofill or auto suggest in textbox

[dwarek]

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

 

[steve the fish]

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!