AddItem and Clear Giving Errors when Run

Hi All

I am trying to use the AddItem to create a List from a named Range. But when I run the form I am getting Compile Error: Method or Data Member not Found.
I have this code running successfully in another spreadsheet fine.
I am using excel 2010 and the spread was originally setup in Excel 2003

Please Login or Register  to view this content.

Any help thanks

Tony

The Error comes as soon as I run the form and it highlights the .AddItem when I goto debug the macro. It also fails on .Clear as well.
I have tried using list as well with similar error.

Thanks
Tony

Hi Norie

Yes it gives me the same error on both.
It appears that it is unable to find the additem, Clear and even the List functions.
Is there something within excel I need to turn on to get these to work.

Thanks

Tony

Hi Norie

I have attached the full workbook.

Thanks

Tony

Now i feel like a real dil

Thanks very Much