creating a popup answer for an average range of cells

  • Thread starter Thread starter 1zipsails
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
EXCEL FORMULA 0
Blank cell with average formula 1
Average Ranges of Cells, Return Separate Value for Each Range 5
Highest 50 Day Rolling Average 1
Average of cells that exclude conditional formats? 5
Averaging data across a date range 1
Average last 3 in range 13

Back
Top