Excel style sum of selected cells

[Ron Huebner]

I would like to implement an Excel like numerical sum of the selected cells in a grid. Excel puts this value in a status bar panel and the value is updated whenever the selected cells are changed. Please suggest an approach to handle updating the sum of the selected cells when the selections in a grid are changed by mouse or keyboard.

[Administrator]

You could try the SelectionChanging event to handle this. This event should be raised anytime the selection changes, whether from teh keyboard or from the mouse. You could loop through the e.Range object adding up the cell values to get the sum.