| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox value to be placed into a textbox
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox value to be placed into a textbox
The same way you did the value in column one. select it.
"Corey" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste values from TextBox to ListBox | Excel Programming | |||
| listbox and textbox problem | Excel Programming | |||
| Retaining focus on a textbox / listbox item pair after validation = false. | Excel Programming | |||
| Copying data from a listbox to a textbox | Excel Programming | |||
| Populating TextBox Value--using ListBox | Excel Programming | |||
Linear Mode
