Auto List Members
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: Set DDown = CommandBars("myToolbar").controls.add (Type:=msoControlDropdown) with DDown .Caption = "myDropDown" ' Caption does appear in Autolist members .Style = msoButtonAutomatic 'Style does not appear neither does the mso constants end with Why is this so inconsistent? Or is it something I don't know? Your help on any or all aspects of this problem would be appreciated Thanks David G |
Auto List Members
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: |
Auto List Members
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 |
Auto List Members
I reread your original post, and it looks like you are using DDown as
an object reference to a dropdown box, for which a button style (msoButtonAutomatic) is not appropriate. From a brief check of the MSDN website, the Style property only applies to objects instantiated as CommandBarButton or CommandBarComboBox. What are you declaring the DDown object as? --JP On Apr 29, 6:19*pm, David_G wrote: 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- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 07:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com