Include cell text in MsgBox ??
On May 17, 2:02 am, dim wrote:
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)
|