View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
tc tc is offline
external usenet poster
 
Posts: 40
Default 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)