Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |