
In my case it is 12.75 - make it 12 to simplify the arithmetic. Scroll to the bottom of the properties and find the width. To find out the scrollbar width, drag a scrollbar on to the canvas. In the simple case, there is only one column width and only one column so the horizontal scrollbar will appear if (columnwidths + vertical scrollbar width) > width I haven't tried this with XL97 so I don't know if this would work for that version. The horizontal scrollbar appears if ((sum of columnwidths) + vertical scrollbar width) > (width / column count) Now, just select the ComboBox, bring down the drop down list by clicking on the right arrow and use the Mouse Wheel to scroll the list up and down. Since in also includes the size of the vertical scrollbar. By default, the Column Width is set to the Width. In the simple case, find out what Width has been set to and subtract the scrollbar width from that value. Width: This is set by stretching the drawingĬolumnWidths: This will set the widths of the columns. For the simple case, set the Column Count to 1 The main players areĬolumnCount: Listboxes allow the data to snake through multiple columns but that is a different story. As mentioned in other replies, this is a combination of the ColumnWidth and the Width.
