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

Include cell text in MsgBox ??
 

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

--
Gary''s Student - gsnu200786


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

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)

Include cell text in MsgBox ??
 

Thanks folks,

Thats just what I was looking for.

L8rs.