Include cell text in MsgBox ??

[dim]

Hi folks,

Is there a way I can include the text contained within a cell in my message
box.

Something like?

Sub ShowEmployeeName ()
NameValue = Range("A1").Value
AgeValue = Range("A2").Value

MsgBox "The employee (NameValue), is (AgeValue).", vbOkOnly + vbInformation,
"Employee"
End Sub

Thanks for any ideas....

 

[Gary''s Student]

Sub durla()
v = Range("A1").Value
MsgBox ("the value is: " & v)
End Sub

 

[tc]

Hi folks,

Is there a way I can include the text contained within a cell in my message
box.

Something like?

Sub ShowEmployeeName ()
NameValue = Range("A1").Value
AgeValue = Range("A2").Value

MsgBox "The employee (NameValue), is (AgeValue).", vbOkOnly + vbInformation,
"Employee"
End Sub

Thanks for any ideas....

Dim NameValue As String, AgeValue As String

NameValue = Range("A1").Value
AgeValue = Range("A2").Value

MsgBox ("The employee " & NameValue & " is " & AgeValue)

 

[dim]

Thanks folks,

Thats just what I was looking for.

L8rs.