In the editor choose Insert -> Module and copy and paste the code below into that module and make any changes To put the code into your workbook (I recommend testing on a copy of your workbook first!!) and then press + to open the VB editor. As set up now, it places the new drop downs one rightĪfter the other with no spacing between them and all are left aligned to the source drop down box. Hopefully the names are clear enough to give you an idea of what you might want to change. There are other variables and constants you can change to control how and where the added controls are placed. You'll need to know the name of that control and change the reference to "Drop Down This code assumes you have one combo box already on the sheet all set up the way you want with regards to size and the source list. To see the steps for changing the Size setting in Excel 2010, you can watch this short Excel video tutorial.You could do it with some VBA code. That should fix the ComboBox sizing problem! Watch the Combo Box Sizing Video In the Format Shape dialog box, in the Size category, remove the check mark for Lock Aspect Ratio, and click OK On the Ribbon, under Drawing Tools, click Format, and click the Dialog Launcher for the Size group. To select the ComboBox, type its name in the Name Box, and press Enter On the Developer tab, click the Design Mode command. That’s not too helpful a feature! Fix the Problem in Excel 2010įortunately, the problem is easy to fix in Excel 2010, if you follow these steps.
In other workbooks, the ComboBox is so narrow that you can’t see it at all.
In the screen shot below, the ComboBox is about 1/4″ wide, instead of filling the entire cell. In the ComboBox, you can control the font size and the number of visible items in the list.Īlthough this technique works nicely in Excel 2007, and earlier versions, you might have a problem with the ComboBox size in Excel 2010. With Excel VBA programming, you can add a ComboBox to the worksheet, to show the data validation list. However, the font size is very small, and can’t be adjusted, and you can only see 8 items at at time. With Excel data validation, you can create drop down lists on a worksheet.
0 kommentar(er)
