Help with arrays

[montanaheather]

Hello,

I am writing code to store and later paste/print items from an array based on user input and selection of checkboxes. The array seems to work fine for the first For/Next, but when the next "n" integer comes around, I get an out of range error. I have no idea how to fix this and I am open to any suggestions!

Thank you!

Please Login or Register  to view this content.

[ajryan88]

Hi,

Could you please upload a sample workbook with your code in it, along with some instructions on how to use the workbook to reproduce the error, and what outputs you would expect to see if the code ran perfectly?

Thanks

[montanaheather]

Hello,

It's not a workbook, but a word document. It's in its infancy, but the idea is that the user would check boxes on the page, then enter a "note" related to the checkboxes ("tags"). Each note can have one more chechbox tags.

It should loop through all the checkboxes for each note, then ask for another note, and repeat, until the user decides there are no more notes to tag/assign checkboxes to.

DOes that help?

[montanaheather]

here is the attachment

[Norie]

The error is because when using ReDim Preserve you can only redim the last dimension.

What exactly are you trying to get in the array?

Does it need to be 2-dimensional?

[montanaheather]

I thought it might be the ReDim, but I dno't understand how to fix it or why that line of code is wrong. I am trying to have the array "remember" each note and the checkboxes that relate to the note so that, later, I can print out the array such that the notes are matched with the one or more checkboxes that were checked for it. Ideally, the print out would look like this:

Note1 Tag/Checkbox1 Tag/Checkbox2
Note2 Tag/Checkbox1 Tag/Checkbox2
Note3 Tag/Checkbox1 Tag/Checkbox2


Etc., until the user has entered all the notes they would like to enter. The output feeds into a larger macro, so this is just a small piece (which is why it looks odd, I am sure).

Any help you can give is hugely appreciated.