All of a sudden getting an error with newly created UserForms with ComboBoxes

[philfloyduk]

I'm currently making changes to repair booking spreadsheet and I've started getting an error message on new forms created when trying to the the .list information in ComboBoxes. I have lots of ComboBoxes already that I've created in previous days that work fine but all of a sudden I get an error when creating new forms. I've tried inserting a blank form and adding a combobox to see if that works but I get the same error:

Run-time error '381
'Could not set the List property. Invalid property array index'.

I'm using the following code to set the list property;

ComboBox1.List = Sheets("info").Range("a1:a4").value

Any help will be much appreciated

Thanks in advance

Phil

 

[Norie]

Phil

I was going to suggest you check if the RowSource has been set elsewhere but if these are newly created comboboxes then that would be unlikely.

Rather than List have you considered actually using RowSource?

Combobox1.RowSource = "Info!A1:A4"

Or even something like this.

Worksheets("Info").Range("A1:A4").Name = "ComboDataList"
 
ComboBox1.RowSource = "ComboboDataList"

 

[philfloyduk]

Hi Norie and thank you!

Is there any reason why the method I've used in the rest of the forms I've created worked before but not when I'm creating new ones now? Your method has solved the problem which is obviously the most important thing but it seems odd to me?

Thanks again


Phil

 

[Norie]

Phil

As far as I can see what you have should work.

Are you sure there wasn't anything going on with the RowSource property when your code didn't work?

The code I posted is just basically setting that property, and if there had been a problem with it previously that might be why it works.

Hard to tell without more info, eg is there any other code.