Subscript out of Range when Populating Combobox from One Dimensional Array

[Hmerman]

Hello,
I have a Combobox on a Userform that I want to populate with a Dynamic One Dimensional Array that currently has 26 elements. But the .List method gives me a Subscript Out of Range error.

My code:

cbVragVerwysing.List = NewArr(tempCntr)

Can someone please give me advice or help on how to make it work?

Regards,
Herman

 

[Rick Rothstein]

Hello,
I have a Combobox on a Userform that I want to populate with a Dynamic One Dimensional Array that currently has 26 elements. But the .List method gives me a Subscript Out of Range error.

My code:

cbVragVerwysing.List = NewArr(tempCntr)

NewArr is the array of data correct? If so, just assign the array directly...

cbVragVerwysing.List = NewArr

 

[Hmerman]

NewArr is the array of data correct? If so, just assign the array directly...

cbVragVerwysing.List = NewArr

You are brilliant. Thank you.

Yes, you are correct NewArr is the array of the data. I did as you said and it worked perfectly.

Thanks again.

Regards,