LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display remaining txt file which overflowed MsgBox display? EagleOne Excel Discussion (Misc queries) 1 November 2nd 06 01:10 PM
display cell value in msgbox formatted as % rgarber50 Excel Discussion (Misc queries) 5 July 10th 05 03:27 PM
Display MsgBox thru automation Per-Olof Excel Programming 1 January 13th 04 07:39 AM
DISPLAY RANGE AT MSGBOX GUS Excel Programming 2 September 25th 03 08:38 PM
Specify font for MsgBox display? shockley Excel Programming 1 September 11th 03 01:50 PM


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"