Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 789
Default 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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent cell/array references from changing when altering/moving thecell/array nme Excel Discussion (Misc queries) 1 September 19th 08 01:53 PM
meaning of : IF(Switch; Average(array A, array B); array A) DXAT Excel Worksheet Functions 1 October 24th 06 06:11 PM
Array problem: Key words-Variant Array, single-element, type mismatch error davidm Excel Programming 6 November 9th 05 05:54 AM
Array problem: Key words-Variant Array, single-element, type mismatch error davidm Excel Programming 1 November 8th 05 04:21 AM
variant array containing cel adresses convert to actual ranges-array Peter[_21_] Excel Programming 5 December 10th 03 09:50 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"