Userform - filling textboxes from a ListBox Selection

A userform I am trying to finish populates a listbox of returns from a search query. I want then when an item double Clicked to fill a userforms text boxes

All textboxes are called "Ddtxt_1" up to "Ddtxt_46"

The textbox numbers are in the same order as the listbox index

I want to display the results so they can be edited - Ddtxt_20 does not exist but the listbox index entry for column 20 will exist

This will not work and stalls with ListIndex & i highlighted

Any Ideas how to change>>>

Please Login or Register  to view this content.

Try these modifications

Please Login or Register  to view this content.

Hi Maudibe, this is stalling on line indicated but it does display the first correct entry Ddtxt_1 from Listbox 0 ...(ListBox1.List(i)="AC")....

you have a variable lr but it is not referenced ... any ideas?? "Cells(lr, i + 1)………….Application Defined or Object Defined error"

Please Login or Register  to view this content.

Hi Maud

The value in the text boxes should be the text box order is equal to the column order of the selected value EXCEPT for Ddtxt_20 (doesnt exist) which ignores column 19

This was original working code that I wanted to change

Please Login or Register  to view this content.

Any pointers appreciated.. variable lr was declared in a an earlier reply post which wrote the same boxes back to the worksheet - I didn't notice it was there, apologies

This does what you want except it errors for column AH, so if you fix that it's working.

Please Login or Register  to view this content.

Sorted AH and works, thankyou Bakerman2

14 of Ddtxt_ display a date and the format has appeared as "mm dd yyyy" - just checked the list index values and same so need to look at that if cant be changed at this point..