VBA Excel 2007 macro dies in Excel 2002

Posted by Rob A on Stack Overflow See other posts from Stack Overflow or by Rob A
Published on 2010-05-13T06:01:25Z Indexed on 2010/05/13 6:04 UTC
Read the original article Hit count: 365

Filed under:
|
|
|

Hi,

I have just tried to send a workbook to a friend that has a chart with a drop-down box on it. In excel 2007 I have used:

If Chart2.Shapes(2).ControlFormat.ListCount = "16" Then

To check the size of the list so that it doesnt get entered in again (resulting in an extremely long list that repeats itself). This line works well in Excel 2007, but gives a Object doesn't support this property or method. error in Excel 2002.

What is the difference between working with shapes in 2002 vs 2007?

© Stack Overflow or respective owner

Related posts about excel-vba

Related posts about excel-2007