By a double click in listbox, a textbox to fill another UserForm

**Dirk55** · 08-09-2011, 02:08 PM

Dear Forum Users,

This is my first post, I am very poor in English and I hope you understand my question.

I have a UserForm with 8 text boxes. (UserForm1) on the UserForm is a button that opens another UserForm
On this second UserForm (FrmMedewerkers) is also a listbox. (4 columns)
When I double click on a line, I want the value of this rule and the second column in the textbox6 of UserForm1 is put down

I use the following code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards,

Dirk
cross-posting
http://www.mrexcel.com/forum/showthread.php?t=570409

Dirk.

**6StringJazzer** · 08-09-2011, 03:23 PM

There is no built-in double-click event for a listbox. It is more of an industry standard to add an "OK" button below the listbox to press when the user has made a selection.

I do not understand this:

I want the value of this rule and the second column in the textbox6 of UserForm1 is put down

I don't know what "this rule" means. Do you mean that you want the value in the second column of the selected row of the listbox to be copied to textbox6 in UserForm1?

**Dirk55** · 08-09-2011, 03:39 PM

Originally Posted by 6StringJazzer

There is no built-in double-click event for a listbox. It is more of an industry standard to add an "OK" button below the listbox to press when the user has made a selection.

I do not understand this:
I don't know what "this rule" means. Do you mean that you want the value in the second column of the selected row of the listbox to be copied to textbox6 in UserForm1?

Yes, I mean this

Regards,

dirk