array
 

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.

array
 

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

april27 wrote:
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.

array
 

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)

"april27" wrote in message
...
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.

array
 

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.

" skrev:

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

april27 wrote:
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.

array
 

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

april27 wrote:
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.

" skrev:

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

april27 wrote:
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.