Autocompletar en Excel sin importar el orden
Tengo este código para autocompletar una lista desplegable pero... Lo que deseo es que se autocomplete sin importar el orden en que escriba:
Ej:
-Los gatos toman leche
-Las vacas comen pasto
Y si escribo : gatos me salga la frase "Los gatos toman leche"
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim xCombox As OLEObject Dim xStr As String Dim xWs As Worksheet Dim xArr Set xWs = Application.ActiveSheet On Error Resume Next Set xCombox = xWs.OLEObjects("Cuadrito") 'desaparece el cuadro combinado' With xCombox .ListFillRange = "" .LinkedCell = "" .Visible = False End With If Target.Validation.Type = 3 Then Target.Validation.InCellDropdown = False Cancel = True xStr = Target.Validation.Formula1 xStr = Right(xStr, Len(xStr) - 1) If xStr = "" Then Exit Sub With xCombox .Visible = True .Left = Target.Left .Top = Target.Top .Width = Target.Width + 5 .Height = Target.Height + 5 .ListFillRange = xStr If .ListFillRange = "" Then xArr = Split(xStr, ",") Me.Cuadrito.List = xArr End If .LinkedCell = Target.Address End With xCombox.Activate Me.Cuadrito.DropDown End If End Sub Private Sub Cuadrito_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) Select Case KeyCode Case 9 Application.ActiveCell.Offset(0, 1).Activate Case 13 Application.ActiveCell.Offset(1, 0).Activate End Select End Sub