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

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

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

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

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

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

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

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

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

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.
DebugCompile, correct any error and hopefully it comes back.

NickHK

wrote in message
...
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

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

Another brain tapped! Thanks

"Nick HK" wrote:

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.
DebugCompile, correct any error and hopefully it comes back.

NickHK

wrote in message
.. .
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