View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 172
Default Listbox value to be placed into a textbox

Got:
Private Sub CommandButton3_Click()
TextBox1.Value = ListBox1.Value
End Sub

BUT, the Listbox has 2 Columns with BOUNDCOLUMN = 2

How do i get the 2nd Column Value in the Textbox instaed of the 1st ?
"Corey" wrote in message ...
I have not used a Listbox before and have populated it.
But i want when CommandButton3 is clicked, the
value HIGHLIGHTED in Listbox1 to be Placed into Textbox1.

How do i do this?

Corey