Adding to AutoComplete programmatically

[Guest]

Dear Group

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

Best regards

Jim...

 

[Edgar]

Jim

Do you mean Autocorrect?

If so the following should do it:

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

HTH

Edgar

 

[Guest]

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

 

[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

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.