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
Harald Staff - 24 Jan 2006 12:20 GMT
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
> Hi All
>
[quoted text clipped - 9 lines]
> Excel 2000
> VBA IDE 6.0.8714