Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to build the contents of a multi-column combobox through code.
I have an array of the data I need to load, I can do this by using a combination of 'additem' and them 'column' property of the combo box. This all works satisfactorily however I have a problem setting the column headings, or more accurately setting these so they cannot be selected. I have tried using the setting the 'ListHeaderCount' property to 1, and this inserts the separator, but does not stop the top header row from being able to be selected. If you base a combobox on a named range by setting the combobox's 'RowSource' as the named range. The row above each column is automatically inserted as a non-selectable header. How do you do this in code, building the Combobox through code? PWS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MultiColumn ComboBox Value set/display | Excel Programming | |||
Hiding a column in a multicolumn combobox | Excel Programming | |||
Display multicolumn box | Excel Programming | |||
display multicolumn box | Excel Programming | |||
Multicolumn Combo Box | Excel Programming |