resizing listbox columns in excel userform
 

Hi
I have a listbox in an excel visual basic userform with multiple
columns.

I want to resize some of the columns of the text in the box. How do I
do this?

If I use

userform.listbox1.columnwidths=100, it only resizes the leftmost
column,

Any suggestions much appreciated.

Thanks

resizing listbox columns in excel userform
 

userform1.listbox1.columnwidths = 100; 75; 150

A trip to help might be informative as there is more to learn.
--
Regards,
Tom Ogilvy



"u9946675" wrote:

Hi
I have a listbox in an excel visual basic userform with multiple
columns.

I want to resize some of the columns of the text in the box. How do I
do this?

If I use

userform.listbox1.columnwidths=100, it only resizes the leftmost
column,

Any suggestions much appreciated.

Thanks