software

Hi :

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?

Thanks

Charles--
mrdata
------------------------------------------------------------------------
mrdata's Profile: www.excelforum.com/member.php...oamp;userid=17899
View this thread: www.excelforum.com/showthread...hreadid=519021
mrdata Wrote:
gt; Hi :
gt;
gt; What I would like to do is create a list of commonly typed text (Text
gt; used Daily) and have the cells in the column where these are typed.
gt; Charles
I suppose you could make a list in the column and then hide the rows,
that would by my first thought--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519021Macros 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 gt;,
mrdata gt; wrote:

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


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

Thanks
Charles--
mrdata
------------------------------------------------------------------------
mrdata's Profile: www.excelforum.com/member.php...oamp;userid=17899
View this thread: www.excelforum.com/showthread...hreadid=519021