VBA Editor not showing list of properties & methods

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
The VBA IDE does not always pop-up the list of available properties and
Click to expand...
methods when the period (.) is added. This behaviour is mostly exhibited
following a collection (e.g., worksheets()).
 
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 said:
The VBA IDE does not always pop-up the list of available properties an
Click to expand...
methods when the period (.) is added. This behaviour is mostly exhibite
following a collection (e.g., worksheets())
 
Back
Top