List box in a User form

[Neville Bentley]

Hi out there,

Can anyone help? I have a listBox in a user form.
When I run the form I get the horizontal scroll bars at the bottom of the list box and I cannot seem to find where to switch them off as they are not needed.

Any Idea's?

Cheers

Neville

 

[xld]

Look at the ColumnWidth property.

 

[Neville Bentley]

Thanks for that "xld",

There is nothing in the ColumnWidth property. Do I set a value in there, as there are no choices?

 

[xld]

Yes, experiment with the value because it is probably taking your data width as a default.

 

[Neville Bentley]

Yeah Thanks again,

I fiddled with a few values and they worked. Again thanks.

Cheers

N