View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dim dim is offline
external usenet poster
 
Posts: 123
Default Include cell text in MsgBox ??

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....