MsgBox Array..Solved

Nimrod · May 24th, 2002, 05:47 PM

Hello fellow Xler's:
I'm sure there is a way to create an message from a group of cell values but I'm at a loss to fiqure it out.

Problem :
I have values in the Range A1:F3 that I want to put in a message in the following format:
Line1 = A1 & A2 & A3
Line2 = B1 & B2 & B3
Line3... etc

Presently the only way I can figure out how to do this is by Msgbox ( A1 & A2 & A3 & chr(13) & Chr(10) & .... etc

Is there a way to pass these cells as an array to the MsgBox instead of doing it in this long method ?

[ This Message was edited by: Nimrod on 2002-05-24 17:13 ]

Nimrod · May 24th, 2002, 06:12 PM

Ow well thanks guys I've got what seems to be a solution :

Code:

For Ln = 0 To 3
                For Col = 2 To 4
                    Msg = Msg & .Cells(DbRw + Ln, Col).Value & Tb
                Next 'col
                Msg = Msg & NL
            Next ' line

May 24th, 2002, 06:12 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Ow well thanks guys I've got what seems to be a solution : Code: For Ln = 0 To 3 For Col = 2 To 4 Msg = Msg & .Cells(DbRw + Ln, Col).Value & Tb Next 'col Msg = Msg & NL Next ' line

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 05:47 PM	#1
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Hello fellow Xler's: I'm sure there is a way to create an message from a group of cell values but I'm at a loss to fiqure it out. Problem : I have values in the Range A1:F3 that I want to put in a message in the following format: Line1 = A1 & A2 & A3 Line2 = B1 & B2 & B3 Line3... etc Presently the only way I can figure out how to do this is by Msgbox ( A1 & A2 & A3 & chr(13) & Chr(10) & .... etc Is there a way to pass these cells as an array to the MsgBox instead of doing it in this long method ? [ This Message was edited by: Nimrod on 2002-05-24 17:13 ]