Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display of $ in Msgbox
In XL2000, I use this to display the check# & amount a check was written
for: MsgBox "Check for $" & Range("I3").End(xlDown)(1, 5) & _ " was #" & Range("I3").End(xlDown)(1, 2) An appearance problem is that I would like an amount like $12.00 to show as that rather than $12, or $12.80 instead of $12.8 - OK? I can't use a text value because these items are summed at the bottom of the sheet. Any way to get what I want? -- David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display of $ in Msgbox
Hi
try: MsgBox "Check for $" & format(Range("I3").End(xlDown)(1, 5),"0.00") & _ " was #" & Range("I3").End(xlDown)(1, 2) -- Regards Frank Kabel Frankfurt, Germany David wrote: In XL2000, I use this to display the check# & amount a check was written for: MsgBox "Check for $" & Range("I3").End(xlDown)(1, 5) & _ " was #" & Range("I3").End(xlDown)(1, 2) An appearance problem is that I would like an amount like $12.00 to show as that rather than $12, or $12.80 instead of $12.8 - OK? I can't use a text value because these items are summed at the bottom of the sheet. Any way to get what I want? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display of $ in Msgbox
Frank Kabel wrote
MsgBox "Check for $" & format(Range("I3").End(xlDown)(1, 5),"0.00") & _ " was #" & Range("I3").End(xlDown)(1, 2) Easy when you know how. Thanks. I was thinking in that direction after posting and realizing how stupid I was to say that something in a MsgBox couldn't be text. Never would have come up with the proper syntax on my own, though. -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
Display MsgBox thru automation | Excel Programming | |||
DISPLAY RANGE AT MSGBOX | Excel Programming | |||
Specify font for MsgBox display? | Excel Programming |