Autocomplete from a list on the worksheet

Macros are suspended when you're in edit mode, so you wouldn't be able
to use one to do autocomplete.

It would be possible to build a userform for data entry that could do
this, but I'm not sure it would be appropriate, nor am I sure what you
mean that autocomplete doesn't always work...

In article <mrdata.245tvy_1141500602.1958@excelforum-nospam.com>,
mrdata <mrdata.245tvy_1141500602.1958@excelforum-nospam.com> wrote:

> What I would like to do is create a list of commonly typed text (Text
> used Daily) and have the cells in the column where these are typed.
> Autocomplete by looking at the list so that the whole word does not
> have to be typed over and over again
> The built in autocomplete works to some extent but not always.
>
> Can it be done?

Autocomplete was disabled in the options menu.
Seems to work now

Thanks
Charles