VBA Excel 2007 macro dies in Excel 2002
- by Rob A
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,…