Databases
StackOverflow2013
Postsdbo
POExcel VBA ComboBox DropDown Button Size--changed itself
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExcel VBA ComboBox DropDown Button Size--changed itself
    primarykey
    data
    text
    <p>I have a workbook with several comboboxes (and listboxes) and a lot of vba written around them. I've used the same code in the Workbook_Open procedure to format them for weeks, without any major trouble. </p> <p>Last night I remoted-desktopped in to my work computer (for the 2nd time ever) to edit some other parts of the code (nothing that touched the box properties at all). At one point after a while, the formatting of all the boxes, list and combo, went crazy. The right side scroll bars on the list boxes got huge, and huge scroll bars appeared at the bottom of them too. And the Dropdown button on the comboboxes got huge too--as wide as the box just about. </p> <p>I closed and reopened Excel, and all the boxes went back to their former happy state, except for one, which still has a dropdown button as wide as the box. My vba formatting code doesn't help. Rebooting the computer doesn't help. I compared the properties window for two boxes that should be identical (except for name and left position), and nothing is different there. </p> <p>So is there anyway I can tame, reset, or otherwise control this renegade dropdown button? I wish I wasn't even in Excel dealing with this kind of unpredictable behavior, but I'm stuck. </p> <p>Here is my formatting vba: </p> <pre><code> With ThisWorkbook.Sheets(c_stMatrixSheet).OLEObjects(c_stMatrixTypeBox) .Width = 120 .Top = 14 .Left = 878 Call FormatComboBox(.Object) .Object.AddItem c_stAMatrix .Object.AddItem c_stBMatrix .Object.AddItem c_stCMatrix .Object.Text = c_stAMatrix End With </code></pre> <p>...</p> <pre><code>Private Sub FormatComboBox(bxComboBox As msforms.ComboBox) With bxComboBox .Clear .Height = 19.5 .Font.Name = c_stDropBoxFont .Font.Size = 10 .AutoSize = False .Enabled = True .Locked = False .Placement = xlFreeFloating End With End Sub </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USRomnieEE2
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CONow I notice that the whole dropdown box, when the huge button is pressed, is itself huge, or hugely wide, that is. The text is the same size as the normal boxes. And the row height is fine. But the box is super wide, and it has a huge right-side scroll bar in it.
      singulars
      1. POExcel VBA ComboBox DropDown Button Size--changed itself
      1. USRomnieEE2
    2. COWell it's not pretty, but I think I have a workaround. First I format the box with autosize true. Twice, I guess. As the box got wider and the button got smaller on both passes. (Note, none of the text was as wide as my original box width.) Then format the boxes to my desired widths, with autosize false.
      singulars
      1. POExcel VBA ComboBox DropDown Button Size--changed itself
      1. USRomnieEE2
    3. COIn the same vein, in my Workbook_Open method, I actually have to run my format combo boxes routine twice, b/c the listboxes don't populate on the first pass, but do on the 2nd pass. Go figure. Do I curse Excel, vba, or just microsoft in general?
      singulars
      1. POExcel VBA ComboBox DropDown Button Size--changed itself
      1. USRomnieEE2
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload