Include cell text in MsgBox ??

  • Thread starter Thread starter dim
  • Start date Start date
D

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....
 
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....
Click to expand...

Dim NameValue As String, AgeValue As String

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

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