This works great! I have been stuck for days! Thanks!

JLGWhiz wrote:
For a single select listbox you can use the ListBox1.Value or the
ListBox1.Selected(index) syntax, (assuming ListBox1).

Range("A1") = ListBox1.Value
For i = 1 To ListBox1.ListCount + 1
Range("A2") = ListBox1.Selected(i)
Next

Does anybody know of a way to capture a user highlighted item out of a list
box? Is there another tool that would be more appropriate? I would like to
[quoted text clipped - 3 lines]
Thanks
Carrie

--
Message posted via http://www.officekb.com