ComboBox Please help
 

I have a Userform with a Combobox. However, when I open the UserForm the
combobox does not display the first column. I have five columns and all
column are visible except the lst. In the combobox properties I have Bound
Column =1, Column Count = 5 and Column Widths 0.3pt. The column widths in
the combobox are very wide and I also can not narrow the width of the column.
Can someone please help. Thank you very much.

ComboBox Please help
 

Insert the column widths as whole numbers probably 20pt-30pt and insert all 5
like the following. I don't know why you get wide columns with the default
0.3pt but the following seems to work. Just experiment with the numbers to
get the required widths of columns.

30 pt;30 pt;30 pt;30 pt;30 pt

--
Regards,

OssieMac


"TotallyConfused" wrote:

I have a Userform with a Combobox. However, when I open the UserForm the
combobox does not display the first column. I have five columns and all
column are visible except the lst. In the combobox properties I have Bound
Column =1, Column Count = 5 and Column Widths 0.3pt. The column widths in
the combobox are very wide and I also can not narrow the width of the column.
Can someone please help. Thank you very much.

ComboBox Please help
 

I have played with it a bit more and worked out why the first column does not
display and the others display wide.

When the width is 0.3pt it is too narrow to see anything and the remaining
columns that do not have a specified width get a wide default.

If you leave the property blank so that the first column width is not
specified, you see all columns as wide columns (default width)

--
Regards,

OssieMac


"TotallyConfused" wrote:

I have a Userform with a Combobox. However, when I open the UserForm the
combobox does not display the first column. I have five columns and all
column are visible except the lst. In the combobox properties I have Bound
Column =1, Column Count = 5 and Column Widths 0.3pt. The column widths in
the combobox are very wide and I also can not narrow the width of the column.
Can someone please help. Thank you very much.