| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autocomplete from a list on the worksheet
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: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=519021 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autocomplete from a list on the worksheet
Autocomplete was disabled in the options menu. Seems to work now Thanks Charles -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=519021 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autocomplete from a list on the worksheet
mrdata Wrote: 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. 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: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519021 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull list / dropdown data from another worksheet? | Excel Discussion (Misc queries) | |||
| Protecting a worksheet containing XML List | Excel Discussion (Misc queries) | |||
| Leave list box unprotected while protecting worksheet | Excel Discussion (Misc queries) | |||
| Create a list in one worksheet of the other worksheets' names | Excel Worksheet Functions | |||
| Sorting a worksheet with drop list | Excel Discussion (Misc queries) | |||
Hybrid Mode
