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.
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.