Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with active X combo box
I have managed to add it and define the list etc but I must have
inadvertently changed some property and the list appears to the right of the combo and is just a thin sliver (can't read the names). I have been through all the properties and none of them seem to affect it. The list width is the obvious one but it doesn't seem to work. Anyone any ideas how to get it in the right position and right width? Thanks, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with active X combo box
Is this combobox on a worksheet, or a userform (the properties are slightly
different). The main properties that would affect the list are the RowSource (or ListFillRange), ColumnCount, ColumnWidths, and TextAlign. From what you are describing I am guessing you have multiple columns but the first one (or at least the first one showing) is blank, so that squeezes the column you actually want to see off to the right and almost completely off the list. You need to look carefully at your rowsource. If the column you want to see is the second column in the rowsource, set the width of the first one to zero, for example ColumnWidths = 0";1.5" "Mark Stephens" wrote: I have managed to add it and define the list etc but I must have inadvertently changed some property and the list appears to the right of the combo and is just a thin sliver (can't read the names). I have been through all the properties and none of them seem to affect it. The list width is the obvious one but it doesn't seem to work. Anyone any ideas how to get it in the right position and right width? Thanks, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
Combo Box Forms vs Active X | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
how can I return the active row and active column? | Excel Programming | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |