Hi

Assuming that autocomplete is activated in Options and that "require
variable declaration" also is: Loss of autocomplete usually means that
something is wrong with your code. Ambigious names, use of reserved words,
.... Try Debug Compile and see what happens.

HTH. Best wishes Harald

"RMJames" skrev i melding
ups.com...
Hi All

I am having trouble with autocomplete that has stop working in the IDE
while coding. Then it will suddenly start again for a while, before
stopping...


I have tried restarting excel and the PC but no joy


Any ideals what causes this?


Win 2000
Excel 2000
VBA IDE 6.0.8714