Dim strSomething as String
strSomething = Me.ListBox1.Value
Worksheets("Stuff").Range("B5").Value = strSomething
'--
With a multi-select listbox you have to run a loop.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Carrie_Loos via OfficeKB.com"
wrote in message
Yes, thanks, I did try that without success. And after all I have been
reading in help and other books that I have, I am beginning to wonder if you
can't select a value out of a list box?

Jim Cone wrote:
Try recording a macro while you filter the sheet.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200802/1