If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a popup answer for an average range of cells
How do I Roll over a range of cells and have their average show as a "pop up"?
|
#2
|
|||
|
|||
creating a popup answer for an average range of cells
This will give you an average for each and every selection you make. I'm
guessing it's going to be obnoxious if someone is changing any data. Right click on the worksheet to View source. Paste this in Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not IsEmpty(Target) Then MsgBox ("Average: " & WorksheetFunction.Average(Target.Value)) End If End Sub -- HTH, Barb Reinhardt "1zipsails" wrote: How do I Roll over a range of cells and have their average show as a "pop up"? |
Thread Tools | |
Display Modes | |
|
|