Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box Question
Hello,
I like to write a code to appear the below message in the message box window. Total profit is = Range(A1)-Range(A2)-Range(A3) Total loss is = Range(B1)-Range(B2)-Range(B3) The message can appear as a single line or more. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box Question
John,
Do you mean MsgBox "Total profit is = " & Range("A1") - Range("A2") - Range("A3") & vbCrLf & _ "Total loss is = " & Range("B1") - Range("B2") - Range("B3") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "John" wrote in message ... Hello, I like to write a code to appear the below message in the message box window. Total profit is = Range(A1)-Range(A2)-Range(A3) Total loss is = Range(B1)-Range(B2)-Range(B3) The message can appear as a single line or more. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
One question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |