Collection Method not adding array elements

[icyrius]

Hello VBA masters,

I am trying to add the elements of an array to a collection to find unique elements. These will be later sent to a combobox in a userform.

However, I am not getting any array elements added to the collection. It will be always empty after the loop.

Here is the code

Please Login or Register  to view this content.

Any help will be greatly appreciated. I already spent half a day trying to find my way around this.

Thanks.

[Marc L]

Hi,

maybe try Dictionary object, see in VBA inner help …

[Leith Ross]

Hello icyrius,

What does the data look like in cells H6:H? ?

[icyrius]

They are a series of four digit timestamps like this,
1840
1841
1844
1844
1844
1846
1846
1846
1848
1848
1848

[Leith Ross]

Hello icyrius,

Let rewrite this for you so you can see how to do this correctly.

[icyrius]

Perfect, Thanks!

[Leith Ross]

Hello icyrius,

Is the ComboBox on a UserForm or a Worksheet?

[icyrius]

The code resides inside a UserForm and it is triggered with a Private Sub Userform_Activate()

[icyrius]

And yes, the ComboBox is inside the Userform

[Leith Ross]

Hello icyrius,

This will check if there is data in Range you want to take values from. If there is no data then an alert message is displayed and the macro quits.

This worked in my tests so it should work for you as well. Formatting your code can save you a lot time when troubleshooting code problems. Like my signature says, rushing causes delays.

Please Login or Register  to view this content.

[icyrius]

YES! Thank you so much!

[Leith Ross]

Hello icyrius,

You're welcome.