Advanced Auto-complete/predict/spell

[omairhe]

Hey everyone, hope you're doing ok..

My question is what code will allow me to auto complete auto spell and auto predict a list of words with range name = "DATABASE"

for instance the list DATABASE has words

little mermaid
angel
peter pan
lion king

so let's say that the macro runs in cell A1
I type in cell A1 = "l m" or "lit" or "mer" or "lmerd"
and this should output me "little mermaid"

Kindly note that I want this to be happening in real time so I know I have to stop typing my word which has already appeared and I need to press enter to confirm it.

will appreciate, and thanks in advance.

 

[BQardi]

Not possible!
Macros cannot and will not run while editing a cell...

If you really need this functionality, you can use a textbox and use a macro in the change event of that textbox...
Maybe some inspiration from here: http://www.mrexcel.com/forum/excel-...sic-applications-code-auto-fill-text-box.html

 

[Sektor]

You could effectively use ActiveX Combobox with built-in functionality.

 

[omairhe]

I like the sound of the textbox.. I previously had a textbox but it didn't do the auto-spell thingy..

Thanks, appreciate it.