Combo box column widths

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

If I have a combo box, do all of the column widths have to
be the same size? I want to use a combo box in my macro
that has 6 columns but I haven't been able to adjust the
size of each column. Thanks.
 
Use the ColumnWidths property. Its a string, where each column is delimited
by a semicolon ( ; ). Like this

100; 50; 20

if you leave a column empty, Excel will resize it automatically, like

; 50; 20

and if you set a column to 0, it will be invisible.
 
Look at help on the ColumnWidths property for a combobox . It allows you to
set individual widths.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Width 3
resizing a Combo Box 3
listbox - code to adjust column widths 4
combo box 2
Reference Combo Box to Column of Data 1
ListBox Column Widths 4
combo box - last value 2
Linking Combo Box Values to Access Table 2

Back
Top