Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Display Totals In MsgBox

I have a list of Categories in A7:A23 e.g

Damp
Bad Edges
Burnt
etc etc

In Row C7:Y7 is the total No of Damp boards
In Row C8:Y8 is the total No. of Bad Edges
In Row C9:Y9 is the total No. of Burnt boards
etc etc

Is it possible to sum all NON Blank totals and display them in a MsgBox
when a button is pressed.

E.G this would appear in message box

Damp 250
Bad Edges 100

Total No3's = 350

Hope you can help

Peter

Reply
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
MsgBox Display Michael S. Excel Programming 2 June 16th 05 10:55 PM
Display of $ in Msgbox David Excel Programming 2 September 8th 04 09:38 AM
Display MsgBox thru automation Per-Olof Excel Programming 1 January 13th 04 07:39 AM
Specify font for MsgBox display? shockley Excel Programming 1 September 11th 03 01:50 PM


All times are GMT +1. The time now is 04: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"