+ Reply to Thread
Results 1 to 2 of 2

Array dimension

  1. #1
    Henrietta Klaus
    Guest

    Array dimension

    OK I have a bit of a tricky problem. I define the dimension for an array in
    the code for a userform. the dimension is defiend variably so i cannot
    replace the range with a number. this array is then intended to be used in a
    modul in which a have the major parts of my code. in this modul I also
    declare the array (since otherwise I get an error..dont ask me why). the code
    for the declaration is:

    Public blnCheckBoxArray() As Boolean

    the sub in the userform code that sets the dimension is also public.

    however when I refer to the array in the modul the program does not
    understand, i get error number 9. Index outside of interval. how shall I code
    so that I can use the array in the modul?

  2. #2
    Bob Phillips
    Guest

    Re: Array dimension

    Is that array defined in the userform code module? If so, change it to the
    standard code module.

    --

    HTH

    Bob Phillips

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

    "Henrietta Klaus" <[email protected]> wrote in
    message news:[email protected]...
    > OK I have a bit of a tricky problem. I define the dimension for an array

    in
    > the code for a userform. the dimension is defiend variably so i cannot
    > replace the range with a number. this array is then intended to be used in

    a
    > modul in which a have the major parts of my code. in this modul I also
    > declare the array (since otherwise I get an error..dont ask me why). the

    code
    > for the declaration is:
    >
    > Public blnCheckBoxArray() As Boolean
    >
    > the sub in the userform code that sets the dimension is also public.
    >
    > however when I refer to the array in the modul the program does not
    > understand, i get error number 9. Index outside of interval. how shall I

    code
    > so that I can use the array in the modul?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1