Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox .List problem
I'm using VB6 to create Excel files and add .bas files to it. From VB6, I'm
running a subroutine (macro) in the Excel file (it belongs to a .bas file I just added) that adds an Excel Forms combobox to a sheet and sets its source to a named range on another sheet. Here's the code snippet I'm running: Set CB = WS.DropDowns.Add(Left, Top, 128.25, 15.75) '(Left, Top, Width, Height) With CB .Name = Name .ListFillRange = Source .ListIndex = 0 .DropDownLines = 8 .Display3DShading = False .OnAction = Name & "_Change" End With This all appears to be working (except the .ListIndex is not actually setting the text of the combobox to the first value - this is not my real problem). Next, I'm running the Change event of the combobox I just added (I also added the Change event subroutine through code, in case that matters). In it I have the following line: SelectedValue = WS.DropDowns("cmbServices").List(WS.DropDowns("cmb Services").ListIndex) When I'm in VB6 running this as a macro, the above line errors off saying "Unable to get the List property of the DropDown class". However, if I save the Excel file and open it, then this line of code works perfectly. Any ideas? Thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox .List problem
One other note is that the second part of the line is working. In
SelectedValue = WS.DropDowns("cmbServices").List(WS.DropDowns("cmb Services").ListIndex) The WS.DropDowns("cmbServices").ListIndex does contain a value of zero. So, it does see the object. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
Change Combobox list to list more than 1 cell.value | Excel Programming | |||
Combobox list to leave ONLY related values in list ?? | Excel Programming | |||
Combobox List to list Numerical Values ONLY in Column A is specific Sheet.... | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming |