Auto complete when typing any part of the word

Question

Auto complete when typing any part of the word

How can i autocomplete the text when typing any part of an information inside the ListBox using VBA?

Example:

When you type the "Saints" all options containing this word will be listed / displayed in the listbox.

0

excel vba listbox planilhas autocompletar

Author: LINQ, 2017-05-10

Source

1 answers

score 1 · Accepted Answer

Wave,

First fill in the list then scroll through the items and create the filtered list

Dim i As Integer
'Percorre por todos itens do listbox
For i = 0 To List1.ListCount - 1
'Verifica se o item do listbox esta selecionado
if InStr(List1.List(i),valorDigitado) = 0 then
ListFiltrada.add(List1.List(i))
End If
Next

Something like this, I am without windows to create the precise Code