I tried to use pre-defined array in my code for testing:
comboBoxList = Array("James", "Mary", "Tom", "Beth", "Bob", "Chris", "Daniel", "Lari", "Al", "Teresa")
On the "VBA editor - watches", it display
MyArray(0) : "James"
MyArray(1) : "Mary"
...
...
Then i tried to extract data from worksheet to form an array:
comboBoxList = Worksheets(1).Range("A:A").Value
On the "VBA editor - watches", it display
MyArray(1)
MyArray(1,1) : "James"
MyArray(2)
MyArray(2,1) : "Mary"
...
...
Is there a difference between the 2 arrays as i can't perform array sorting.