Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox selected item?
Hello,
I've created a listbox (lstImportFiles) on my worksheet (admin). I have the range and the cell link (b2). The value of B2 is 3. Now how do I get the value of the selected list item for the worksheet listbox? I didn't quite get that by searching this forum. Maybe I missed it, but I didn't see threads on retrieving the selected item in a Worksheet listbox. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox selected item?
Sub fk()
MsgBox Sheet1.ListBox1.Value End Sub "Webtechie" wrote: Hello, I've created a listbox (lstImportFiles) on my worksheet (admin). I have the range and the cell link (b2). The value of B2 is 3. Now how do I get the value of the selected list item for the worksheet listbox? I didn't quite get that by searching this forum. Maybe I missed it, but I didn't see threads on retrieving the selected item in a Worksheet listbox. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox selected item?
P.S. I assumed a single column, single select list box. If multicolumn,
single select, the code would return the value of the bound column. If multiselect the code fails. "Webtechie" wrote: Hello, I've created a listbox (lstImportFiles) on my worksheet (admin). I have the range and the cell link (b2). The value of B2 is 3. Now how do I get the value of the selected list item for the worksheet listbox? I didn't quite get that by searching this forum. Maybe I missed it, but I didn't see threads on retrieving the selected item in a Worksheet listbox. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox selected item?
Hey,
That didn't work: I tried: Sheets("DataValues").Select Range("j3").Value = Sheets("adminview").Shapes("lstImportFiles").Value I got: Run time error '438' Object doesn't support this property or method. "JLGWhiz" wrote: P.S. I assumed a single column, single select list box. If multicolumn, single select, the code would return the value of the bound column. If multiselect the code fails. "Webtechie" wrote: Hello, I've created a listbox (lstImportFiles) on my worksheet (admin). I have the range and the cell link (b2). The value of B2 is 3. Now how do I get the value of the selected list item for the worksheet listbox? I didn't quite get that by searching this forum. Maybe I missed it, but I didn't see threads on retrieving the selected item in a Worksheet listbox. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete selected Item from listbox | Excel Programming | |||
How to get the index in VBA of the selected item in a ListBox | Excel Programming | |||
Need selected item from listbox after double click | Excel Programming | |||
Listbox - write newly selected item back to the worksheet | Excel Programming | |||
Count number of selected item in Listbox | Excel Programming |