Goto:
http://support.microsoft.com/default...b;en-us;829070

And look down listing for:
How to obtain the selected items in a multiple select ListBox control;

This should get you started.

Jim May

"Colin Telfer" wrote in message
:

I have a worksheet which in which i want to start up a list box where i can
choose from the list to enter into the cell, the cell in question happens to
be a merged cell of 4 cells.

Also i want the list to be already loaded when the worksheet is opened.

Can anybody help me with setting this up?

Thanks in advance