Listbox multiselect- VBA code error

[sassy1978]

I'm a bit of a beginner at using visual basics to code. I have inserted an activex listbox into my sheet. Its is multiselect. I want the selectiong to be inserted into a single cell on a seperate sheet. I have found the code to do it and had it working on my Excel 2007 at home but i opened it at work on Excel 2010 and I get the error 'Compule error: cannot find project or library"
I can't work out what the error is. this is the code I have written:

Please Login or Register  to view this content.

Would anyone be able to point out where I have gone wrong.
Thanks so much

[Norie]

The code might not be the problem.

Open up the VBA Editor (ALT+F11), goto Tools>References...

Is there anything marked as 'MISSING'?

PS Can you use code tags when posting code?

[sassy1978]

Yes it Says "MISSING Microsoft Calendar Control 2007"


Sorry about not using the Code tags

[Norie]

Try unchecking Microsoft Calendar Control 2007 and then try the code again.

[jaslake]

Hi sassy1978

Calendar Control no longer is included in Excel 2007 and later. There are available non ActiveX options that are fairly easily implemented.

If interested I'll work with you.

Edit:

Fix your Code Tags!!

[sassy1978]

Thank you for your help Tha worked.

I have one other issue howerever.I have several multiselect listboxes boxes and I want the user to be able to select from these listboxes and have the results inputted into a single cell. However with the code i have it will only allow the reults from one listbox to be displayed. Is ther a way for this to be done. here's my code

Please Login or Register  to view this content.

Thank you