Hi all,

OK, I have a macro that opens a new worksheet in Excel. That worksheet has a listbox called lstBank. I want to get the value in lstbank. No matter what I try, i can't seem to find out how to do something as simple as put a msgbox up with the highlighted member of the list in it.

msgbox lstbox

only returns a null string.

I can't seem to find the answer anywhere on the net, and i know this should be the easiest thing in the world.

Thanks,
Joshua Wise