| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Message Box "Value"
Hi All, I have written a macro to do several calculations in several sheets. Now I want to put the answer in a message box. The answer is in a defined field. All I am trying to do is "the answer is" & "here I want to give address of the defined filed" How can I do that? Thanks for ur help. Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#2
|
|||
|
|||
|
Do you mean
MsgBox "The answer is in A1" or MsgBox "The answer is " & Range("A1").Value -- HTH RP (remove nothere from the email address if mailing direct) "saziz" wrote in message ... Hi All, I have written a macro to do several calculations in several sheets. Now I want to put the answer in a message box. The answer is in a defined field. All I am trying to do is "the answer is" & "here I want to give address of the defined filed" How can I do that? Thanks for ur help. Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#3
|
|||
|
|||
|
Bob, I mean the second of ur two. MsgBox "The answer is " & Range("A1").Value I will try this. Thanks Bob Phillips Wrote: Do you mean MsgBox "The answer is in A1" or MsgBox "The answer is " & Range("A1").Value -- HTH RP (remove nothere from the email address if mailing direct) "saziz" wrote in message ... Hi All, I have written a macro to do several calculations in several sheets. Now I want to put the answer in a message box. The answer is in a defined field. All I am trying to do is "the answer is" & "here I want to give address of the defined filed" How can I do that? Thanks for ur help. Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#4
|
|||
|
|||
|
Hi Bob, I tried following: MsgBox "The Average is" & Sheet3!Range("p2").Value It says 'Object required' Syed Bob Phillips Wrote: Do you mean MsgBox "The answer is in A1" or MsgBox "The answer is " & Range("A1").Value -- HTH RP (remove nothere from the email address if mailing direct) "saziz" wrote in message ... Hi All, I have written a macro to do several calculations in several sheets. Now I want to put the answer in a message box. The answer is in a defined field. All I am trying to do is "the answer is" & "here I want to give address of the defined filed" How can I do that? Thanks for ur help. Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#5
|
|||
|
|||
|
you extract the value from Sheet3 at p2 cell, it should sheets("Sheet3").Range("p2").Value try this MsgBox "The Average is" & sheets("Sheet3").Range("p2").Value -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#6
|
|||
|
|||
|
Thank you Anil it is working. How can I restrict decimal places, it is giving me all 14 decimal places. Is there a format syntax? Thank you -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
|
#7
|
|||
|
|||
|
Yes use format(sheets("Sheet3").Range("p2").Value,"#.##") this will give two decimal places MsgBox "The Average is" & format(sheets("Sheet3").Range("p2").Value,"#.##") -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=382585 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
| when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| Error Message appearing when saving a file | Excel Discussion (Misc queries) | |||
| #num! error message | Excel Worksheet Functions | |||
Hybrid Mode
