Right click and iterate through selection

[Paulymon]

I want to drag a selection box around a group of cells in one column
(a5..a10) for example and then when the right-click is pressed give the user
the option to click "Process" and then iterate through each cell entry in the
range.

How do I do that? I 've got a fair idea for the right-click thing but I'm
not sure how to step through each cell in the range and process the numbers.

Thanks for any help
Paul

[Leith Ross]

Hello Paul,

Here is a code example that sums the values of the cells selected when the user Right Clicks the selection. The sum of the Selected cells is placed below the last cell in the selection.

Remember that setting Cnacel to True in this event will disable the context menus.

Example:

Please Login or Register  to view this content.

Sincerely,
Leith Ross