Hi
I want to resize some columns in a listBox in code.
The form is set to sizable and the listBox anchor settings are such that the listbox grows with the form.
There are three columns, two of which I want to remain as fixed widths and one should grow when the listbox does. So the simple calculation for the (growing) column width is...
ListBox.Width minus total width of fixed columns.
My problem is that the result of listbox.width remains the same, even after resizing the form. The listbox is visibly larger but calling the width property in VBA always gives the width of the listbox as designed.
Is there another way to get the actual width of the listbox once the user has resized it?
Thanks
Neil
I want to resize some columns in a listBox in code.
The form is set to sizable and the listBox anchor settings are such that the listbox grows with the form.
There are three columns, two of which I want to remain as fixed widths and one should grow when the listbox does. So the simple calculation for the (growing) column width is...
ListBox.Width minus total width of fixed columns.
My problem is that the result of listbox.width remains the same, even after resizing the form. The listbox is visibly larger but calling the width property in VBA always gives the width of the listbox as designed.
Is there another way to get the actual width of the listbox once the user has resized it?
Thanks
Neil