I have a combo box with 12 columns on my form. However,
when I click on the drop down arrow, I can only see 10 of
the columns. How can I see all of the columns? I have
tried changing column widths but that hasn't helped.

Thanks for the help......

columnwidths in conjunction with the listwidth property of the combobox
would be the properties to use.

for example, I did 13 columns
ColumnWidths:
20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20
pt
ListWidth:
280pt
columncount:
13
Rowsource:
Sheet1:A2:M25
columnheads:
True

for the listwidth
add up all your columnwidths and add some pts for the vertical scroll bar.
(I added 20 pts).

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
I have a combo box with 12 columns on my form. However,
when I click on the drop down arrow, I can only see 10 of
the columns. How can I see all of the columns? I have
tried changing column widths but that hasn't helped.

Thanks for the help......

Tom.........thanks for the help......JT

-----Original Message-----
columnwidths in conjunction with the listwidth property
of the combobox
would be the properties to use.

for example, I did 13 columns
ColumnWidths:
20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20
pt;20 pt;20 pt;20
pt
ListWidth:
280pt
columncount:
13
Rowsource:
Sheet1:A2:M25
columnheads:
True

for the listwidth
add up all your columnwidths and add some pts for the
vertical scroll bar.
(I added 20 pts).

--
Regards,
Tom Ogilvy

"JT" wrote in
message
...
I have a combo box with 12 columns on my form. However,
when I click on the drop down arrow, I can only see 10
of
the columns. How can I see all of the columns? I have
tried changing column widths but that hasn't helped.

Thanks for the help......


.