How to turn on the pop-up "alternatives" while editing in the VBA Editor

[EagleOne]

2003/2007

Most of the time, while editing pop-up "suggestions" are available. Other times no.

i.e. if I enter "myRange." alternatives may or may not appear.

What causes the pop-up "suggestions" to turn off or stop popping up?

How does one force it on - if currently off?

Thanks

EagleOne

 

[Dave Peterson]

If you declare your variables as the correct type:

Dim myRange as Range
not
Dim myRange as object 'or As Variant

Then the VBE will help out using its intellisense.

That said, I've seen it disappear and I don't know why. IIRC, it sometimes
comes back on its own--or I close excel and restart it. (Not much of a helpful
answer, huh?)

 

[EagleOne]

Ah Ha!

I did not realize that the Dim statements were being read while editing.
Saying that, it makes sense - else how does VBA know what alternatives
to pop-up. Another Da! moment.

Thanks Dave

 

[Dave Peterson]

Glad the lightbulb came on!

Ah Ha!

I did not realize that the Dim statements were being read while editing.
Saying that, it makes sense - else how does VBA know what alternatives
to pop-up. Another Da! moment.

Thanks Dave

 

[NickHK]

After following Dave's advice, if you feel Intellisense is not appearing
when it should, I find this is often due to a compile error somewhere.
Debug>Compile, correct any error and hopefully it comes back.

NickHK

 

[EagleOne]

Another brain tapped! Thanks

After following Dave's advice, if you feel Intellisense is not appearing
when it should, I find this is often due to a compile error somewhere.
Debug>Compile, correct any error and hopefully it comes back.

NickHK