Hi,
I have a userform with a combobox which I built in Windows (Excel 365).
The combobox autocompletes nicely in Windows.
I have set MatchEntry = 1 - fmMatchEntryComplete.
However on the Mac the MatchEntryComplete isn't working correctly.
My combobox is linked to a range of cells in a worksheet which is a list of names.
For example,
1. Louis
2. Luciamo
etc
On the Mac when I type "L" into the combobox (disabled arrow so it looks like a standard textbox) it fills "Louis" in (as expected, being the first word on my list beginning with "L").
When I then type "U" to get to Daniel, the box fills as follows: "Luouis". I.e it correctly finds Daniel when "LU" is typed but doesn't remove the previous selection.
Is there some code I can use as a workaround?
Thanks
I have a userform with a combobox which I built in Windows (Excel 365).
The combobox autocompletes nicely in Windows.
I have set MatchEntry = 1 - fmMatchEntryComplete.
However on the Mac the MatchEntryComplete isn't working correctly.
My combobox is linked to a range of cells in a worksheet which is a list of names.
For example,
1. Louis
2. Luciamo
etc
On the Mac when I type "L" into the combobox (disabled arrow so it looks like a standard textbox) it fills "Louis" in (as expected, being the first word on my list beginning with "L").
When I then type "U" to get to Daniel, the box fills as follows: "Luouis". I.e it correctly finds Daniel when "LU" is typed but doesn't remove the previous selection.
Is there some code I can use as a workaround?
Thanks