array

[Guest]

i have a user form. the user is to submit a value in a textbox. i then want
to create an array that contains several textboxes. these textboxes shall be
given the value of the "main" textbox. i thoought i could to this with the
use of an array but i get an error message all the time. i think it is
because i declared the array badly. can someone please help me with this one?
i want the array to be avaliable globally i.e. i want to declare it public.

 

[paul.robinson]

Hi
What did you do and what was the error message?
regards
Paul

 

[Bob Phillips]

Without seeing the code it is difficult to make any meaningful comment.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

well the error message said something like strings etc. defined by you are
not allowed in an object module (i think). See i want to declare the array
whereever possible and then use it in the user form. i hev tried to declare
it in module, worksheet and workbook but i get error every time.

"(e-mail address removed)" skrev:

 

[paul.robinson]

Hi
I'm still not much wiser...
You say you want an array of textboxes, but I suspect you want an array
of values of textboxes?You might even be better off with a collection
rather than an array.
Without seeing your code I'm reluctant to put effort into guessing what
you want and finding that is not what you meant at all. Neither is
anybody else I suspect.
Sooo... bit of code please.

regards
Paul