Set form's listbox ColumnWidths before loading rows

[drag1c]

Hi,

I am using two forms:
1.

2. 2nd form has listbox in it with combobox and textbox.

When I use 1st form and press button "Change", it opens 2nd form and loads data inside but .columnwidths is not as supposed to be.
Where I should write code to load .columnwidths before data is loaded inside listbox ?

I've tried UserForm_Initialize() in Form2, but it didn't work.
I've tried to use Button_Click() Event also with code inside and it didn't work.
I've tried to use UserForm_Activate() in Form2, but it didn't work.

Of course, If I load Form2 and start manually input data, .columnwidths is good.

Here is example how it looks when I open Form2 via Form1:

Does anyone have solution?

 

[drag1c]

I've solved it.

I've used vbTab instead to put material in 2nd column, as list(i,1)

Topic can be closed.