Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include cell text in MsgBox ??
Thanks folks,
Thats just what I was looking for. L8rs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiply Cell Values which include text units | Excel Worksheet Functions | |||
IF function results to include both text and cell value | Excel Discussion (Misc queries) | |||
How do I include part of a cell in text (string?) in another cell? | Excel Worksheet Functions | |||
How do I include TEXT in the same cell with a FORMULA? | Excel Discussion (Misc queries) | |||
MsgBox containing text from cell | Excel Programming |