View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Listbox value to be placed into a textbox

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

works fine for me. Suggest your Boundcolumn property is set to 1.

--
Regards,
Tom Ogilvy

"Corey" wrote in message
...
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