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