Ultimately, I need a user to be able to select one out of 406,396 individual values, probably out of a list box (if they can hold that many lines??) on a userform.

The values are each unique -- an ID number

My first thought was to simply plug all 406,396 values into a massive array:
myarray = (1,2,...406,396). Using a loop code, I prepared my numbers to be dumped into an array with line continuations after every 11th value like this:

"107894,107896,107901,107902,107905,107908,107909,107910,107913,107915,107917 _"


There are 36,945 lines like the above. I quickly leaned that Excel permits a maximum of 25 line continuations...

Ideas? Any reccomendations generally about handling such large amounts of data would be appreciated. I would prefer NOT to dump these numbers in an actual worksheet. That is, if it is possible, I would like to have the numbers "in" the VBA code itself...by means of an array? a collection?

-- Jason