Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Cell Total
I would like to know if there is a way to take the running
sum cell that I have and have it move up or down the page as I scroll. Or how to make that value on a toolbar. Someway that I can see the total from anywhere on the sheet I have other then a freeze pain way. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Cell Total
Create a floating toolbar (called, say, "Running Total"), put a single text
menu item on it, and then put this code in the ThisWorkbook module: Private Sub Worksheet_Change(ByVal Target As Range) CommandBars("Running Total").Controls(1).Caption = _ WorksheetFunction.Sum(Range("A1:A1000")) 'or whatever total End Sub That's the basic idea; I'll leave the refinements to you. -- Vasant "John" wrote in message ... I would like to know if there is a way to take the running sum cell that I have and have it move up or down the page as I scroll. Or how to make that value on a toolbar. Someway that I can see the total from anywhere on the sheet I have other then a freeze pain way. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Cell Total
Just another idea. You didn't say which version you have. In Excel XP, one
can bring up the worksheet "Watch" window. You can add the cell in question to this Watch Window and have it available no matter what sheet you are on. It's designed for this purpose. :) HTH. -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "John" wrote in message ... I would like to know if there is a way to take the running sum cell that I have and have it move up or down the page as I scroll. Or how to make that value on a toolbar. Someway that I can see the total from anywhere on the sheet I have other then a freeze pain way. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Wrong total but add each cell gives the correct total | Excel Worksheet Functions | |||
Create a floating cell that totals a column of numbers | Excel Discussion (Misc queries) | |||
Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
Floating cell containing a "Running Total". | Excel Discussion (Misc queries) | |||
Floating Total Row | Excel Worksheet Functions |