Change format of combobox using vba

[IM4FLSt]

Hi everyone,

I am curently writing an excel spreadsheet with a couple drop down boxes, the form control combobox, not an activex control.

I have a macro in vba that should change the list reference of the combobox, but I get 'run-time error 32809 Application-defined or object-defined error'. The error occurs on the first line of the following two codes.

Here are the two different codes I have tried:

ActiveSheet.Shapes("Drop Down 2").ControlFormat.ListFillRange = Range("L1") <== Error occurs here

and

ActiveSheet.Shapes("Drop Down 2").Select <== Error occurs here
With Selection
.ListFillRange = Range("L1")
End With

The error does not occur on excel 2010, but it does occur on my excel 2003. I have tried recording a macro while performing the change manually and I get the second macro above. After recording the macro, I try running it and it comes up with the same error.

Anyone have ideas?

Thanks for your help

 

[IM4FLSt]

I believe I have found the answer. I created the spreadsheet using the new .xlsm file format and excel 2003 had issues with it. If I save it using excel 2010 as .xls, I have no issues.