Auto-complete not showing all the option

[tm5000]

Hi,
I am currently working on a small library inventory. I have about 1100 items typed in. I realized that the auto-complete does not show me all the options.

For example, there are four items that starts with "Iceland," but when I type in "i" excel shows me only one option.

I know it's not a spacing issue. I found one way to fix it. That is

1. Fill a black cell with 30 or more letters
2. Erase all the letters
3. Start typing
​

This will show me all the options, but it is somewhat troublesome.

Do any of you know how to easily fix the issue? (How to enable the Excel to show all the option)

Thank you in advance,
TOMO

 

[crimson_b1ade]

try using a combobox with this code

Private Sub ComboBox1_Change()

ComboBox1.DropDown

End Sub

 

[tm5000]

Thank you for your quick reply.
Does this work on Office 2008 for Mac?

I'm not sure how to work it out.

Thanks

 

[crimson_b1ade]

i don't think so since it's vba and macs use Applescript. which unfortunately for you I know nothing about.

perhaps someone else on here can lend a hand who has Applescript knowledge.