Array in MsgBox

[southbean]

Hello All,

Is it possible to have an array in a message box?

I have command button that executes an Excel export routine which creates a worksheet for each available gadget.

At the end of the routine I would like to have a message box indicating each gadget exported.

Is this possible? If so, I would appreciate any/all suggestion on how to do this.

Thanks!

- TM

 

[abaldwin]

Actually I would not use a message box. I would use a small form with either a grid or a picture box on it.

Instead of firing a msg box simply open the "message form" and fill the grid or print the array to a picture box.

If you build the msg to display by looping through an array and concantenating the contents into a string and then display a message you may have a msg box that is larger than the screen and no scrolling. Could get ugly.

Have a try at the form is my suggestion.

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[Remou]

Create a string:

Join(astr, vbCrLf)

 

[southbean]

abaldwin & Remou

Thank you both for your replies!

abaldwin: your solution may be better for my purpose here.

However, I will take a shot at both.

Thanks again!

- TM

 

[abaldwin]

Just wanted to allow you to avoid....

"Array in a message box no room for my text.
The little Lord Programmer lay down his sweet head.
The code on the pages it drives me insane,
But little lowly programmer keeps typing away.
End users dont like me but the project is done.

Array in a message no room for my Texxxxxxttttt."


LOL


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.