Userform Intialize selecting listbox to textbox

[stevenbehr]

Hi,


I have 10 listboxes in my userform and I can double click each listbox lines and populate information from there to 10 textboxes.


Im wondering if I can in Userform Intialize, once the userform opens that the information in listboxes be populated automatically to the textboxes.


I have a code below but doesn't do anything really just selects the first list but no double click

Please Login or Register  to view this content.

Thanks


Steve

[bakerman2]

I suppose the Listboxes have multiple lines in them since you speak of doubleclick to populate the textboxes.

So my question is how to know at startup which line needs to be transferred ???

[mikerickson]

How are the list boxes populated? RowSource or an .AddItem approach or ....

Which item in the listbox do you want to go to the text boxes?