Show values of Array Elements in a MsgBox

[Tim]

Is this possible? As my code goes through a worksheet looking for problems, I would like to collect the information in an array. At the end, I want a single MsgBox to show all of the values (elements) in the array.

 

[Damon Ostrander]

Hi Tim,

Yes, you can easily do this. Just concatenate the text you want to display for each item onto the previous text, putting a linefeed-carriage return between each. For example, say you have an account number that is a text string that you want to put in the array every time a problem occurs with that account, and that account number is in a string variable named AcctNo. Define another string variable MsgArray. Each time a problem occurs, add it to the MsgArray string:

MsgArray = MsgArray & vbCrLf & AcctNo

Now at the end of the program display the message:

MsgBox MsgArray, _
vbExclamation, _
"Problem Account List"

 

[rasosina]

found the solution:

If search_results Is Nothing Then
...

End if