Use MsgBox to display the contents of an entire array

**Dralky** · 03-22-2013, 07:11 PM

Dear whoever reads this,

I have an array of dynamic length which automatically increases in length and populates each additional cell in the array using an IF statement. At the end of the macro I need to show the contents of the entire array using the MsgBox. So my beginning code looks like this.

Please Login or Register  to view this content.

And then I want something that says like:

Please Login or Register  to view this content.

**JBeaucaire** · 03-22-2013, 10:48 PM

You'll need to cycle through those elements and create a displayable string... keep in mind a MsgBox is not unlimited real estate:

Please Login or Register  to view this content.

You could use & "," in place of & vbNewLine to separate the values by a comma.

Maybe simplest of all:

Please Login or Register  to view this content.

**Dralky** · 03-22-2013, 11:59 PM

Thank you very much. I realize you're right - MsgBox won't expand forever. Where I really want this to go is into an email, though the process should be virtually identical, right?

**JBeaucaire** · 03-23-2013, 10:38 AM

That should certainly work.

If that takes care of your question, select Thread Tools from the link at the top of the page and set this thread to SOLVED. Thanks.