Dual entering

Hillsy7,

Alright, so I think I understand the issue now. The problem is that its dual-entering and you do not want it to input the information anywhere other than the userform. In my test workbook (which is attached), I did the following to get it to work:

-Created a module that contains two public variables: txtActive and lbxSelection
(txtActive will be the active textbox name that got double-clicked and lbxSelection will be the double-clicked value of the listbox)
-Created a function that gets called when a textbox on the first userform is doubleclicked
-The function sets the txtActive public variable to the active textbox's name and then opens the second userform.
-The second userform sets the double-clicked value of the listbox to the lbxSelection public variable
-The function then makes the txtActive textbox text = lbxSelection.

See the attached workbook to see how it works. Let me know if you're looking for something different and I didn't actually understand your issue.

Hope that helps,
~tigeravatar