PDA

View Full Version : [SOLVED:] Help with MsgBox Function



lbartowski
06-08-2010, 12:36 PM
Keep in mind, I'm a newbie.

Here is part of my code:


vOut = ("First:" & vFirst & "Last:" & vLast & "ID:" & vID)
MsgBox vOut


How do I get each item (first, last, and ID) to show up on different rows in my message box? The way I have it now, it shows up all on 1 row of the message box?

Any help is appreciated.

Kenneth Hobs
06-08-2010, 12:43 PM
Dim vOut As String, vFirst As String, vLast As String, vID As Integer
vFirst = "Kenneth"
vLast = "Hobson"
vID = 1
vOut = Join(Array("First: " & vFirst, "Last: " & vLast, "ID: " & vID), vbCrLf)
MsgBox vOut

p45cal
06-08-2010, 12:46 PM
vOut = ("First:" & vfirst & vbLf & "Last:" & vlast & vbLf & "ID:" & vid)