Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoComplete error in (my?) Excel
Hi all,
I have just noticed an error with the autocorrect feature that is causing me some problems in one of my spreadsheet programs. I have a VBA Workbook_Open routine that adds autocorrect entries for each letter of the alphabet "a" to "A" etc. and then removes them in a BeforeClose routine. The problem comes when trying to autocorrect two adjacent rows. I set up a little test in a blank workbook and found the same problem. Try this: Add an autocorrect entry for "a" to "A". Type "a" in cell A1, text changes to "A" Type "a" in cell A2, text stays as "a" But, if you leave a row out and now type "a" in cell A4 the text autocorrects. The error only occurs when trying to autocomplete two adjacent rows. There is also an error once you have autocorrected say B10 and then try to autocorrect B5. I havent noticed this before and am wondering if it is some setting on my home PC that is different to my work PC. I would be grateful if someone could check if this also occurs with their Excel so I can shed some light on the issue. Many Thanks Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoComplete error in (my?) Excel
If you turn off the "enable autocomplete option" in tools options edit,
the autocorrect works. Greetings from NZ Bill K "Lee Meadowcroft" wrote in message ups.com... Hi all, I have just noticed an error with the autocorrect feature that is causing me some problems in one of my spreadsheet programs. I have a VBA Workbook_Open routine that adds autocorrect entries for each letter of the alphabet "a" to "A" etc. and then removes them in a BeforeClose routine. The problem comes when trying to autocorrect two adjacent rows. I set up a little test in a blank workbook and found the same problem. Try this: Add an autocorrect entry for "a" to "A". Type "a" in cell A1, text changes to "A" Type "a" in cell A2, text stays as "a" But, if you leave a row out and now type "a" in cell A4 the text autocorrects. The error only occurs when trying to autocomplete two adjacent rows. There is also an error once you have autocorrected say B10 and then try to autocorrect B5. I havent noticed this before and am wondering if it is some setting on my home PC that is different to my work PC. I would be grateful if someone could check if this also occurs with their Excel so I can shed some light on the issue. Many Thanks Lee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoComplete error in (my?) Excel
Hi Bill,
I've tried that and it hasn't worked, maybe its just because im running xl2000 on this comp. Possibly it was a bug that was fixed. Lee Bill Kuunders wrote: If you turn off the "enable autocomplete option" in tools options edit, the autocorrect works. Greetings from NZ Bill K "Lee Meadowcroft" wrote in message ups.com... Hi all, I have just noticed an error with the autocorrect feature that is causing me some problems in one of my spreadsheet programs. I have a VBA Workbook_Open routine that adds autocorrect entries for each letter of the alphabet "a" to "A" etc. and then removes them in a BeforeClose routine. The problem comes when trying to autocorrect two adjacent rows. I set up a little test in a blank workbook and found the same problem. Try this: Add an autocorrect entry for "a" to "A". Type "a" in cell A1, text changes to "A" Type "a" in cell A2, text stays as "a" But, if you leave a row out and now type "a" in cell A4 the text autocorrects. The error only occurs when trying to autocomplete two adjacent rows. There is also an error once you have autocorrected say B10 and then try to autocorrect B5. I havent noticed this before and am wondering if it is some setting on my home PC that is different to my work PC. I would be grateful if someone could check if this also occurs with their Excel so I can shed some light on the issue. Many Thanks Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Autocomplete | Excel Worksheet Functions | |||
Autocomplete in Excel | Excel Discussion (Misc queries) | |||
is there an autocomplete for numbers in excel? | Excel Discussion (Misc queries) | |||
AutoComplete in EXCEL | New Users to Excel | |||
autocomplete in excel | Excel Discussion (Misc queries) |