ExcelBanter - ListBox chaning size

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ListBox chaning size (https://www.excelbanter.com/excel-programming/362521-listbox-chaning-size.html)

ben

ListBox chaning size

Hi
Any clue why when I do the following assignment to a listBox it reduces
the size of the list box
[...]
lst.List = Application.Transpose(lstv)
[...]
IS there a way to fix the dimension of the listbox?
Help appreciated here
Thanks
Ben

Nigel

ListBox chaning size

There is a listbox width property that you can set to a predefined value.

--
Cheers
Nigel

"ben" wrote in message
oups.com...
Hi
Any clue why when I do the following assignment to a listBox it reduces
the size of the list box
[...]
lst.List = Application.Transpose(lstv)
[...]
IS there a way to fix the dimension of the listbox?
Help appreciated here
Thanks
Ben

All times are GMT +1. The time now is 01:16 AM.