| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete (?) in code not working
Your assistance please...
Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
It is called autolist members under the tools=Options menu in code
settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
Tom,
Followed your instruction. And no luck. Guess I'll have to reload. But a thought - recently had 97 and 2k loaded (in different folders) on my machine and they were both doing OK. Now neither shows the autolist. Do you think that the problem might be there??? Be aware that Option Explicit is Always on Variables are declared All temp folders and recycle bin are cleaned at least once a day (sometimes more) (my Internet Temp fills up fast). All Options are checked. Tried unchecking and rechecking to make sure. I do get the Auto Quick tips!!! Did the 'run' thing both before and after I rebooted. Sure miss that list!!! Thanks for your help and patience!!! -- sb "Tom Ogilvy" wrote in message ... It is called autolist members under the tools=Options menu in code settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
If you want to find the cause, then I think you will have to retrace your
steps and find out what changed during the period when the lists stopped showing up. This would be useful in any event, because unintalling Office doesn't necessarily clear out everything, so you could have some residual environment stuff left (which could be the culprit). -- Regards, Tom Ogilvy "steve" wrote in message ... Tom, Followed your instruction. And no luck. Guess I'll have to reload. But a thought - recently had 97 and 2k loaded (in different folders) on my machine and they were both doing OK. Now neither shows the autolist. Do you think that the problem might be there??? Be aware that Option Explicit is Always on Variables are declared All temp folders and recycle bin are cleaned at least once a day (sometimes more) (my Internet Temp fills up fast). All Options are checked. Tried unchecking and rechecking to make sure. I do get the Auto Quick tips!!! Did the 'run' thing both before and after I rebooted. Sure miss that list!!! Thanks for your help and patience!!! -- sb "Tom Ogilvy" wrote in message ... It is called autolist members under the tools=Options menu in code settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
Tom,
Again - much thanks. I'll start looking... My only concern now is that it was working before I went home yesterday and I haven't changed anything (that I know of). -- sb "Tom Ogilvy" wrote in message ... If you want to find the cause, then I think you will have to retrace your steps and find out what changed during the period when the lists stopped showing up. This would be useful in any event, because unintalling Office doesn't necessarily clear out everything, so you could have some residual environment stuff left (which could be the culprit). -- Regards, Tom Ogilvy "steve" wrote in message ... Tom, Followed your instruction. And no luck. Guess I'll have to reload. But a thought - recently had 97 and 2k loaded (in different folders) on my machine and they were both doing OK. Now neither shows the autolist. Do you think that the problem might be there??? Be aware that Option Explicit is Always on Variables are declared All temp folders and recycle bin are cleaned at least once a day (sometimes more) (my Internet Temp fills up fast). All Options are checked. Tried unchecking and rechecking to make sure. I do get the Auto Quick tips!!! Did the 'run' thing both before and after I rebooted. Sure miss that list!!! Thanks for your help and patience!!! -- sb "Tom Ogilvy" wrote in message ... It is called autolist members under the tools=Options menu in code settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
Tom,
Success! Still am not sure what the culprit was, but found this Started dummy code and typed 'application' and as soon as I entered the '.' the autolist appeared. Any thoughts? It wasn't working with other objects, but now is... Also found a Temp folder (I had overlooked) and it was stuffed. Cleared it out (after the above). Its still a mystery - but fixed (for now). Your advice helped... Thanks! -- sb "Tom Ogilvy" wrote in message ... If you want to find the cause, then I think you will have to retrace your steps and find out what changed during the period when the lists stopped showing up. This would be useful in any event, because unintalling Office doesn't necessarily clear out everything, so you could have some residual environment stuff left (which could be the culprit). -- Regards, Tom Ogilvy "steve" wrote in message ... Tom, Followed your instruction. And no luck. Guess I'll have to reload. But a thought - recently had 97 and 2k loaded (in different folders) on my machine and they were both doing OK. Now neither shows the autolist. Do you think that the problem might be there??? Be aware that Option Explicit is Always on Variables are declared All temp folders and recycle bin are cleaned at least once a day (sometimes more) (my Internet Temp fills up fast). All Options are checked. Tried unchecking and rechecking to make sure. I do get the Auto Quick tips!!! Did the 'run' thing both before and after I rebooted. Sure miss that list!!! Thanks for your help and patience!!! -- sb "Tom Ogilvy" wrote in message ... It is called autolist members under the tools=Options menu in code settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete (?) in code not working
Tom,
A quick follow up... The problem resurfaced. The computer had been shut down over the weekend and after booting up - there it was. Typing Application. into the code window restored the autolist. Also notice that Excel takes a very long time to load the first time after turning the computer back on. Any thoughts? Be aware that all this has started since installing both 97 & 2k on the computer (but in different folders). -- sb "steve" wrote in message ... Tom, Success! Still am not sure what the culprit was, but found this Started dummy code and typed 'application' and as soon as I entered the '.' the autolist appeared. Any thoughts? It wasn't working with other objects, but now is... Also found a Temp folder (I had overlooked) and it was stuffed. Cleared it out (after the above). Its still a mystery - but fixed (for now). Your advice helped... Thanks! -- sb "Tom Ogilvy" wrote in message ... If you want to find the cause, then I think you will have to retrace your steps and find out what changed during the period when the lists stopped showing up. This would be useful in any event, because unintalling Office doesn't necessarily clear out everything, so you could have some residual environment stuff left (which could be the culprit). -- Regards, Tom Ogilvy "steve" wrote in message ... Tom, Followed your instruction. And no luck. Guess I'll have to reload. But a thought - recently had 97 and 2k loaded (in different folders) on my machine and they were both doing OK. Now neither shows the autolist. Do you think that the problem might be there??? Be aware that Option Explicit is Always on Variables are declared All temp folders and recycle bin are cleaned at least once a day (sometimes more) (my Internet Temp fills up fast). All Options are checked. Tried unchecking and rechecking to make sure. I do get the Auto Quick tips!!! Did the 'run' thing both before and after I rebooted. Sure miss that list!!! Thanks for your help and patience!!! -- sb "Tom Ogilvy" wrote in message ... It is called autolist members under the tools=Options menu in code settings. You say all these are checked and you say you always use option explicit, so your objects are declared. I can't say what is causing the problem. Perhaps close excel, clean out your temp directories and reboot. You may have to reinstall office <g. But I would next try to reregister by going to the run option under the start menu and do excel.exe /unregserver then again with excel.exe /regserver -- Regards, Tom Ogilvy "steve" wrote in message ... Your assistance please... Usually when writing code a drop down would appear after adding "." like Activecell. but suddenly it is not there. (sorry I don't remember what it is called) Can anyone steer me in the right direction as to fix this. It has happened with both Excel97 & Excel 2k on my machine. I checked the Tools Options and all the Code Settings are checked. thanks in advance... -- sb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autocomplete not working right | Excel Discussion (Misc queries) | |||
| AutoComplete not working after 4000 entries | Excel Worksheet Functions | |||
| AutoComplete not working | Excel Discussion (Misc queries) | |||
| autocomplete not working | Excel Discussion (Misc queries) | |||
| For Each Code Not Working | Excel Programming | |||
Hybrid Mode
