Excel 20130 VBA inline suggestions

[spyla]

I seem to remember, maybe in excel 2003 VBA, as you are writing vba code suggestions would show up

for example if i typed

Sheets("Sheet1").

after I typed period, suggestions like cells, add, delete, move.... would show up

I am using 2013, how do i get this functionality

 

[Andrew Poulsom]

Do you have 'Auto List Members' checked on the Editor tab of the VBE Options dialog?

 

[spyla]

yes

 

[My Aswer Is This]

spyla

I notice the same thing. It works sometimes but not always. Hopefully someone here will explain it to us. I know if you type "Vba." then it will popup but it gives you a whole list of functions

 

[Andrew Poulsom]

ADVERTISEMENT

You don't get suggestions for your example code.

 

[My Aswer Is This]

I have it checked also using 2013.

 

[spyla]

ADVERTISEMENT

spyla

I notice the same thing. It works sometimes but not always. Hopefully someone here will explain it to us. I know if you type "Vba." then it will popup but it gives you a whole list of functions

when I tried vba. it gave me suggestions but not for my example

 

[My Aswer Is This]

Yes it gives you a whole list of functions.

 

[shg]

Compile errors can break Intellisense. Get a clean compile, then resume coding.

 

[My Aswer Is This]

If you type this: "Cells." then it will popup a list of suggestions like "activate"