On Apr 27, 3:42*pm, JP wrote:
If you declare a Worksheet object and set an object reference to the
sheet, you should get the dropdown after you press "."

For example:

Dim mysht As Excel.Worksheet
Set mysht = Worksheets("Sheet1")
mysht.

HTH,
JP

On Apr 26, 9:02*pm, David_G wrote:



Can anyone assist? *I have a problem with Auto List Members, in
particular how reliably they appear or not appear. *I often use
Sheets("mySheet"). *when I enter the "dot" there is no Auto List
produced. *How come?
Similarly, I am currently working with commandbars, in particular the
code below:- Hide quoted text -

- Show quoted text -

Thanks JP,
I understand where you are coming from on the Sheets example. Yes I
have declared a variable and then referenced it, Yes it works.
However what my question is aiming at is what is the guiding
principle(s) that this behaviour is following?? In other words is
this behaviour random? or is this a Systematic event?
I am working with coding commandbars at the moment and I'm finding
there is a high rate of this type of behaviour, i.e. Auto List not
showed.
So, is it true that if this behaviour occurs (no Auto List Members),
then the object variable is not declared properly? If this is true
then I can point to more instances where the object variable is
declared and there is still no auto list members.
Hopefully I can get an understanding,
Thanks
David G