[RESOLVED] Storing values to be used in later sub routines

[hangarharris]

hi

i have a form with a number of text boxes o it to facilitate user input

one of the text boxes requires a number to be input which redimensions an array

this array takes input from another textbox

however, if i do the coding as a private sub to redimension the array, when i go to input info into it, the array is undimensioned

obviously i need to use something other than a private sub to do this can anyone help

cheers

[BIOSTALL]

You could add 'Option Explicit' at the top of your code and store all your variables there i think If not, it myt be possible to do a public or global sub, not quite sure, sorry

BIOSTALL

[dee-u]

Perhaps Redime Preserve would help you.