Autocomplete in Combobox for Mac

[OldGuy52]

I have a userform combobox that draws its list from a column, then eliminates the duplicates, then alphabetizes the list. I am writing the code in the Office 2013 for windows version of Excel. The application is being used on a Mac, Excel 2011. Everything works great, except when you begin typing the name in the combobox, it only brings up the first character, and then starts typing the rest of the word beginning at the 2nd character. In other words, the autocomplete feature does not work like it does in windows. I'm looking for some help (code examples) to force the combobox to accept multiple character autocomplete.

 

[OldGuy52]

Here is the code I have so far. All of this works both in Windows and OS X, but on the Mac I cannot autocomplete as I type.

Dim MyRow As Long
MyRow = Sheets("Ledger").Range("A5:A62000").End(xlDown).Row

                                     'COMBOBOXT1
Dim rngItems As Range
Dim rngAccts As Range
' Get initial list for ComboboxT1
    Set rngItems = Sheets("Ledger").Range("C6:C" & MyRow)
    ComboBoxT1.List = WorksheetFunction.Transpose(Range(rngItems.Address))
Call RemoveDuplicates(1)
Call SortComboBoxT1(1)

Public Sub RemoveDuplicates(x)
'Remove Duplicates
Dim i As Long
Dim j As Long
i = 0
With ComboBoxT1
    For i = 0 To .ListCount + 1
        For j = .ListCount - 1 To (i + 1) Step -1
            If .List(j) = .List(i) Then
                .RemoveItem j
            End If
        Next
    Next
End With
End Sub

Public Sub RemoveDuplicates4(x)
'Remove Duplicates
Dim i As Long
Dim j As Long
i = 0
With ComboBoxT4
    For i = 0 To .ListCount + 1
        For j = .ListCount - 1 To (i + 1) Step -1
            If .List(j) = .List(i) Then
                .RemoveItem j
            End If
        Next
    Next
End With
End Sub