IDE autocomplete

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

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" <[email protected]> skrev i melding
news:[email protected]...
> 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
>