+ Reply to Thread
Results 1 to 6 of 6

Show sum value of range in msgbox

  1. 06-18-2014, 05:06 AM #1
    TimmerSuds
    TimmerSuds is offline
    Registered User
    Join Date
    06-20-2006
    Location
    Detroit area, Michigan
    MS-Off Ver
    Microsoft Office 365 v16
    Posts
    68

    Show sum value of range in msgbox

    I would like to be able to show a msgbox with the sum of a column in the text.

    The column is E
    The first cell is E2
    The range is every cell in column E (beginning with E2) that has a value in it
    Needs to be rounded to two decimal places

    I've tried the following but it doesn't work correctly:

    Please Login or Register  to view this content.
    Thanks
    Reply With QuoteRegister To Reply
  2. 06-18-2014, 05:09 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Show sum value of range in msgbox

    Try without ()

    Please Login or Register  to view this content.
    Last edited by zbor; 06-18-2014 at 05:18 AM. Reason: And add Application.WorksheetFunction. as TMS showed below
    Reply With QuoteRegister To Reply
  3. 06-18-2014, 05:16 AM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Show sum value of range in msgbox 

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 06-18-2014, 05:18 AM #4
    TimmerSuds
    TimmerSuds is offline
    Registered User
    Join Date
    06-20-2006
    Location
    Detroit area, Michigan
    MS-Off Ver
    Microsoft Office 365 v16
    Posts
    68

    Re: Show sum value of range in msgbox

    This generates a sub or function not defined error
    Reply With QuoteRegister To Reply
  5. 06-18-2014, 05:20 AM #5
    TimmerSuds
    TimmerSuds is offline
    Registered User
    Join Date
    06-20-2006
    Location
    Detroit area, Michigan
    MS-Off Ver
    Microsoft Office 365 v16
    Posts
    68

    Re: Show sum value of range in msgbox

    Quote Originally Posted by TMS View Post 
    Please Login or Register  to view this content.

    Regards, TMS
    Works great - thanks!
    Reply With QuoteRegister To Reply
  6. 06-18-2014, 06:27 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Show sum value of range in msgbox

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how to add counter in msgbox to show remain times the message will show vba code
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2013, 06:46 AM
  2. [SOLVED] Only show msgbox once
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2013, 11:25 AM
  3. [SOLVED] How to show MsgBox if a range of cells in a worksheet of a workbook is already comp.
    By bigpappi23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 10:20 AM
  4. Check range if multiple names exist then show msgbox
    By c.pedersen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 06:23 AM
  5. How to show MsgBox if a any cell value is > 17 in a range
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2011, 08:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1