View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 195
Default 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