Adding to AutoComplete programmatically

J

Jim McLeod

Dear Group

Is it possible to add words to AutoComplete programmatically (VBA or C#)

Best regards

Jim...
 
E

Edgar

Jim

Do you mean Autocorrect?

If so the following should do it:

Application.AutoCorrect.AddReplacement What:="Eg",
Replacement:="Example"

HTH

Edgar
 
J

Jim McLeod

Hi Edgar

Nope, not AutoCorrect.

I want words to complete automatically when you start typing them. However, I'd like the application to have a pre-buffered list when the sheet is opened.

I've been looking for a keyboard event trigger other than OnKey. This method fires macros. I'd like something that triggers a keyboard event across my C# automated application

Best regards

Jim...
 
T

Tom Ogilvy

If you are talking about the intellisense action of completing a word when
typed below a list with a similar word, this is internal to excel. It is
based solely on the proximity entries in that column.

--
Regards,
Tom Ogilvy


Jim McLeod said:
Hi Edgar,

Nope, not AutoCorrect.

I want words to complete automatically when you start typing them.
Click to expand...
However, I'd like the application to have a pre-buffered list when the sheet
is opened.
I've been looking for a keyboard event trigger other than OnKey. This
Click to expand...
method fires macros. I'd like something that triggers a keyboard event
across my C# automated application.
 
Top