Re: Code Completion in VBA?



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.

--
s}
"Markus W." <markus.wallner@xxxxxxxxxx> wrote in message
news:43c50994$0$721$79720d31@xxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
>


.



Relevant Pages

  • Re: Another PythonWin Excel question
    ... >> lookup the Add method for the Worksheets collection. ... VBA will show the ... >> code completion, with all the arguments for the method call. ...
    (comp.lang.python)
  • Re: Another PythonWin Excel question
    ... if you have VBA installed, ... lookup the Add method for the Worksheets collection. ... code completion, with all the arguments for the method call. ...
    (comp.lang.python)
  • Re: Another PythonWin Excel question
    ... I get a "got an expected keyword argument 'after'" from Add. ... > lookup the Add method for the Worksheets collection. ... VBA will show the ... > code completion, with all the arguments for the method call. ...
    (comp.lang.python)