autocomplete method names

[venkman]

Auto-complete for method names of objects in my vba editor is being really flaky. it works sometimes, and then will stop working. auto completion at the end of an "AS" still works fine, but does not work for things like:

Dim x as range
x.Row

where normally row would appear from an autocomplete list.
I assume this is just flaky Microsoft code, but does anyone have some tips on how to get it to work more consistently?

Thanks,
-Venkman

 

[RobBroekhuis]

In tools-options (from VBE), do you have "auto-list members" checked? If yes, maybe Excel is temporarily confused, in which case, restart and see if the problem goes away.
Rob

 

[venkman]

Yeah, it was already selected. Like I said it will work one minute, and then not the next. Had to restart excel twice before it started working again. Any other less obtrusive ways to fix it? What causes Excel to be confused?

-Venkman

 

[RobBroekhuis]

I've found the VBE to be not the most stable of environment, and have occasionally noticed the same problems you're describing - but not frequently enough to be concerned. Although, come to think about it, at my home PC I seem to have the problem a lot more frequently. Not sure what is different.
Rob