Combo box column widths
 

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.

Combo box column widths
 

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.

--
Regards

Juan Pablo González

"JT" wrote in message
...
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.

Combo box column widths
 

Look at help on the ColumnWidths property for a combobox . It allows you to
set individual widths.

--
Regards,
Tom Ogilvy



"JT" wrote in message
...
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.