Problem with setting column widths in forms

[LAF]

I'm trying to use a listbox in a form and set the columns up so that they are the same widths as the sheet, so nothing gets truncated in the form. On the sheet, they are set up to Autofit. I have added code to get the column widths for each column on the sheet. The column widths on the sheet are 10, 39, 13, and 10. I am then trying to bring those columns of data from the sheet into the listbox. When I set the .ColumnWidths for the form equal to 10;39;13;10, it does not display correctly in the form. The columns are way to small. Is there a way to do this to base it off the column width on the sheet so nothing gets truncated?

[snb]

As far as I know there's no direct relationship between the columnwidth in a sheet and the columnwidth in a listbox in a userform. (the fonts may differ etc.).

If you set the Listbox's property columncount to 4, wihtou specifying de columnwidts the listbox should show the columns correstly, but probably the listbox widt isn't correct. So the only thing you have to do is to adjust the Listbox.Width value.

After having done that, you can experiment with columnwidths and listbox.width ( if you have some spare time...)