PDA

View Full Version : Help - Reddim Preserve



lcfc2kotmail
01-10-2008, 10:43 AM
Hi I posted on here a while ago about comapny selections, i have a user form which is run and opens up a list box, and I can select multiple choices from.

If I say select 3 choices, my program should store the contents relating to the selection in an array. however this doesnt work and falls over at the end of my code, I was wondering if somebody could look into this..

I have attached the file - when running the code, run the user form, select say 3 choice A, C and E.

the objective will be to read data relating to these selections into a 2D array for refrencing. Much easier seen in the program, many thanks. e.g. If A is selected the 20 values associated with this choice are read into the array, if B the same C D , E etc...

Many Thanks