Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
Resizing Userform to screen size | Excel Programming | |||
Resizing a listbox | Excel Discussion (Misc queries) | |||
Userform resizing | Excel Programming |