Use autocomplete to provide suggestions in a textbox

[Templemind]

Hello, I have a textbox in a userform that I want to provide suggestions of names as a person is writting from a worksheet (Sheet11, Column A). I believe the autocomplete feature would work for this. The textbox is labeled "Banname". Is this possible?

I have attached the worksheet and here is the code I have for the submit button:

Please Login or Register  to view this content.

[JosephP]

it would be easier to use a combo box and populate it from the sheet-it will match entries as you enter text by default

[Templemind]

Thank you for this. It helped me out a lot.