Using (3) listboxes w/ (1) textbox?

[Todd_M]

Hi-
Ive got three list boxes with info from three diffrent sources. If the user clicks on any selection in any of the three list boxes, then clicks a commandbutton, I want that selection to apear in a textbox. Of course the user can only choose one selection from only one listbox at a time.


Private Sub CommandButton1_Click()
If TextBox1.Text = "" Then
TextBox1.Value = ListBox1.Value or ListBox2.Value or listbox3.value
ListBox1.Value = ""
ListBox2.Value = ""
listbox3.value = ""
Exit Sub
End If
exit sub


Please note that there is 12 textboxes on the userform, there for the selection goes to the first available textbox w/o any text in it. I assuming I would have to write this code 12 times (becouse there 12 textboxes). Thats not a problem. The problem is how does one write a code so that the user can choose any listbox (1-3), any selection in that list box and have it apear in a textbox?

[Todd_M]

Anyone??