the code looks at between 2-4 columns of data which have relationships and creates defined lists to use in listboxes.

The problem is some of these lists ( normally the first one but potentially one or two thers) is more than 256 names ( the named lists are creatd horizontally.)

I cant have all of these list created vertically as there WILL be more than 256 lists.

SO my idea is :

Once data is added to the arrays ( i think this is done first)
Order arrays by number of elements
If array > 240 elements
Then create named list vertically ( then move to next column)
ELse
create rest or named list horizontally.


Pleas help me edit the code below:
hopefully you understand what i mean, please just ask for any further clarification!







Please Login or Register  to view this content.