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

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
|
|

Yeah sorry about that I meant I want to have a listbox on a userform and I
want to add people to a excel sheet called "clients" I need the listbox to
be dynamic. as it hold between 30 - 50 patients we look after.

Hope this is clearer

TIA

Greg