ExcelBanter - View Single Post - How to turn on the pop-up "alternatives" while editing in the VBA Editor

Dave Peterson

Glad the lightbulb came on!

wrote:

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 wrote:

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?)

wrote:

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