How to set variable with index

you need to change the declaration of the variables so you can use them as arrays

Please Login or Register  to view this content.

Hi Andy,

It´s a pleasure to see an answer from you, every time I´m in a dead end regarding VBA and i start searching google I end up on some forum where you´ve solved same (or similar) problem, so I´ve used quite some tips and tricks of yours, thx a lot.

regarding my issue, I have tried what you´ve proposed but its not working, it gives me immidiate error on frm_selection (userform) initialization which states:

"compile error:

Constants, fixed-length strings, arrays, user-defined types and declare statements not allowed as public members of object modules"

I´ve tried to move those variables to below section with dim but than they dont work as desired (just tried to pu msgbox statement with all three collocated together to see if at least that gives the desired result - often when im expecting some value to be outcome i use the msgbox to see if my prediction is actualy true or not, i know i can use debug.print and see that in immidiate window but i prefer msgbox dunno why...;-)...

if it might help i can share the file so u can see the structure of the userforms etc.

EDIT: here is the file

andy sample.xls

To avoid the compile error you can move the declartion of those variables to the Module1 code.
But I'm not sure that is really the best thing to do.

The trouble is I can not see in the project where you actual make use of the 3 arrays.

nvm found what was triggering the issue (not getting the proper value) - as you suggested, i´ve moved the public declaration to module, which solved the issue with the error, but then i was getting another error (9) about subscription or whatever and i found that there was another issue with the inner variable (that "u") which has to be arranged on the fly

Please Login or Register  to view this content.

this now gives the desired values in the msg box, and therefore I belive I´ll be able to use the variables elsewhere

yet again, you´ve said the day for me andy, thx a lot, I hope I´ll be able to finish it up now (i know there will be a lot of coding still but i believe that one wont be as complicated as this userform structure)

also if you´re interested in the complete app, I have no prob to show you after I´m finished, to give you exact idea what was the target....;-) just let me know here or via pm....;-)

once more thx a lot

best regards

Soul

EDIT: oh btw. I belive because the number given to "u" variable above those redims was solid and than few lines below it was moving from 0 to that solid value, that was to me the issue what was triggering vba to fail, cause those variables couldnt pick which one to use - if the solid one few lines above or the one from the "for to" statement....dunno if I explained my train of thoughts or made it more of a mess but i felt i should elaborate on the issue