Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |