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
|