Dear Group

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

Best regards

Jim...

Jim

Do you mean Autocorrect?

If so the following should do it:

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

HTH

Edgar


-----Original Message-----
Dear Group,

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

Best regards,

Jim...
.

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

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" wrote in message
...
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...