Code Completion in VBA?

[Markus W.]

Hello!

Is it possible to switch code completion in VBA on and off? Whenever I write
code in VBA, it is sometimes activated, sometimes not and I have no clue how
it is turned on and off.

Thanks in advance,
Markus

 

[Tony Jollans]

What exactly do you mean by code completion? I am not aware of anything
which auto-completes code without user action but there is an option to
autolist members (Under Tools > Options > Editor tab).

You shouldn't normally experience mixed behaviour. If the option is turned
on (which it is by default) the editor should list members for all typed
variables. I have this nagging feeling at the back of my mind that there
might be some circumstances where it doesn't work but I can't at the moment
think exactly what they are.

 

[Chandan Banga]

Hi,

Kindly go thorough your complete code. This happens due to some error in
coding. Some kind of syntax error and you have missed out some thing in code
and due to this auto completion does not work.

I got this problem once and this was coming in one project but in other
project it was not coming. Then I found a syntax error in code and after
correcting that syntax error it was working.

Regards

Chandan Banga

 

[Perry]

Y're code isn't compiling correctly.
Intellisense is not active in such case.

Use the "Option Explicit" clause in every module, and recompile yr code.
Most likely there is a variable used in yr code that isn't declared
correctly.
In case you don't know what Option Explicit does/is for, look here:

http://msdn.microsoft.com/archive/d...e/en-us/office97/html/output/F1/D6/S5B281.asp

Krgrds,
Perry