resizing listbox columns in excel userform

  • Thread starter Thread starter u9946675
  • Start date Start date
U

u9946675

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
 
userform1.listbox1.columnwidths = 100; 75; 150

A trip to help might be informative as there is more to learn.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delay when userform resizes?? 3
Userforms - listbox gridlines? 1
UserForm ListBox 1
Listbox Problem 1
Userform as childwindow in statusbar not redrawn when Excel window isresized 10
Multi Column UserForm ListBox 1
Resize a row but copy but skip columns I don't want to copy 6
Named cells in an array to a column and to a row 3

Back
Top