Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help displaying array contents
I have an array of strings that I'm wanting to display to the user. All
I've been able to do is use the MsgBox command in a loop to display things one at a time, but I can only get MsgBox to display one line at a time. I want to be able to show all my results in one message box that pops up for the user. My array basically contains results from a spreadsheet update macro (basically a log file). Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help displaying array contents
One way:
Dim i As Integer Dim msg As String For i = LBound(sArr) To UBound(sArr) msg = msg & vbNewLine & sArr(i) Next i MsgBox Mid(msg, 2) where sArr is your array of strings. In article , jsatz wrote: I have an array of strings that I'm wanting to display to the user. All I've been able to do is use the MsgBox command in a loop to display things one at a time, but I can only get MsgBox to display one line at a time. I want to be able to show all my results in one message box that pops up for the user. My array basically contains results from a spreadsheet update macro (basically a log file). Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help displaying array contents
That did it.
Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help displaying array contents
That did it.
Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying cell contents | Excel Discussion (Misc queries) | |||
Displaying Cell Contents | Excel Discussion (Misc queries) | |||
Displaying contents of 2 cells in another | Excel Worksheet Functions | |||
Displaying cell contents on one sheet | Excel Discussion (Misc queries) | |||
Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) |