Really a vague post, Greg. I can't tell whether the listbox is a from the
Control Toolbox or the Forms toolbar. Or whether you want the list box on a
userform or a worksheet. Or where the data is you want to appear in the list
box. It really helps to be very specific. And also not to worry about step
2 (opening a workbook) before you get step 1 working.

--
Jim Rech
Excel MVP
"Greg Brow" wrote in message
...
|I am trying so hard to work these things out how do I use a listbox I would
| like it to show the selections from a column and like it to open a
| corresponding workbook.
|
|
| Thanks in advance
|
| Greg
|
|