VBA Editor not showing list of properties & methods
 

The VBA IDE does not always pop-up the list of available properties and methods when the period (.) is added. This behaviour is mostly exhibited following a collection (e.g., worksheets())

Any ideas how to correct this annoying behaviour

Windows XP, Office X

Thanks
John

VBA Editor not showing list of properties & methods
 

Are your variables declared with a specific type.

Dim rng as Range

for example. If not, then Excel would not know what to show.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
The VBA IDE does not always pop-up the list of available properties and
methods when the period (.) is added. This behaviour is mostly exhibited
following a collection (e.g., worksheets()).

Any ideas how to correct this annoying behaviour.

Windows XP, Office XP

Thanks,
John

VBA Editor not showing list of properties & methods
 

Yes. I always use option explicit. Therefore, the object would be declared (as workbook, as worksheet, etc.

Joh

----- Tom Ogilvy wrote: ----

Are your variables declared with a specific type

Dim rng as Rang

for example. If not, then Excel would not know what to show

--
Regards
Tom Ogilv

"John" wrote in messag
..
The VBA IDE does not always pop-up the list of available properties an
methods when the period (.) is added. This behaviour is mostly exhibite
following a collection (e.g., worksheets())
Any ideas how to correct this annoying behaviour
Windows XP, Office X
Thanks
Joh