Tis me again!

I want to make a message box show the details of two cells.

For example:

Your minimum sales today must be £4500

The 4500 comes from a cell value, which will change from week to week.

How do I change the Msgbox code to do this?

Thanks
Celtic_Avenger
:confused

--
Message posted from http://www.ExcelForum.com

"Celtic_Avenger " ha scritto
nel messaggio ...

I want to make a message box show the details of two cells.



MsgBox (Range("A1") & Chr(13) & Range("A2"))

Thanks for your help cucchiaino,

I have amended that code to the following..........

MsgBox (Range("AC6") & Range("AD6") & Range("AE6"))

to take into account the cells I needed to use......however how do I
now change the Title of the Msgbox?

I want the title to show "Expected Sales" and not "Microsoft Excel".

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/

as shown in Help

msgbox Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales

Note that you don't encase the arguments in parentheses unless you are
getting a return value such as

res = msgbox(Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales)

--
Regards,
Tom Ogilvy



"Celtic_Avenger " wrote in
message ...
Thanks for your help cucchiaino,

I have amended that code to the following..........

MsgBox (Range("AC6") & Range("AD6") & Range("AE6"))

to take into account the cells I needed to use......however how do I
now change the Title of the Msgbox?

I want the title to show "Expected Sales" and not "Microsoft Excel".

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/

Thanks Tom and cucchiaino for all your help.


Celtic_Avenger
:) :) :) :) :

--
Message posted from http://www.ExcelForum.com

This post is extremely helpful to me except that I need to pull the data from
a different sheet. I've played with a couple syntaxes but I'm not getting
the right one. Could someone tell me how to specify which sheet to draw the
data from?

Thanks all!
LDSXena

"Tom Ogilvy" wrote:

as shown in Help

msgbox Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales

Note that you don't encase the arguments in parentheses unless you are
getting a return value such as

res = msgbox(Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales)

--
Regards,
Tom Ogilvy



"Celtic_Avenger " wrote in
message ...
Thanks for your help cucchiaino,

I have amended that code to the following..........

MsgBox (Range("AC6") & Range("AD6") & Range("AE6"))

to take into account the cells I needed to use......however how do I
now change the Title of the Msgbox?

I want the title to show "Expected Sales" and not "Microsoft Excel".

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/

Something like

With Worksheets("Sheet")
msgbox Prompt:=.Range("AC6") & .Range("AD6") & .Range("AE6"), _
Title:="Exptected Sales
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LDSXena" wrote in message
...
This post is extremely helpful to me except that I need to pull the data
from
a different sheet. I've played with a couple syntaxes but I'm not getting
the right one. Could someone tell me how to specify which sheet to draw
the
data from?

Thanks all!
LDSXena

"Tom Ogilvy" wrote:

as shown in Help

msgbox Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales

Note that you don't encase the arguments in parentheses unless you are
getting a return value such as

res = msgbox(Prompt:=Range("AC6") & Range("AD6") & Range("AE6"), _
Title:="Exptected Sales)

--
Regards,
Tom Ogilvy



"Celtic_Avenger " wrote
in
message ...
Thanks for your help cucchiaino,

I have amended that code to the following..........

MsgBox (Range("AC6") & Range("AD6") & Range("AE6"))

to take into account the cells I needed to use......however how do I
now change the Title of the Msgbox?

I want the title to show "Expected Sales" and not "Microsoft Excel".

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/