Worksheet Listbox selected item?

[Webtechie]

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.

 

[JLGWhiz]

Sub fk()
MsgBox Sheet1.ListBox1.Value
End Sub

 

[JLGWhiz]

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]

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.