Cancel as Boolean argument

When I create a worksheet event sub "BeforeDoubleClick", I get the following stub:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

I know what the argument "Target" is, but I don't know when I would ever use the second argument, "Cancel"?

Any ideas on this?

Thank you in advance

Hi Larry,

Excellent question.

You use 'Cancel = True' when you don't want the focus to remain in the cell that was double clicked. This is usually the case when you take some affirmative action based on the 'Double Click' event.

To see how this works, put 'Cancel = True' in an empty Worksheet_BeforeDoubleClick() macro. Notice how the focus is NOT on the cell that was 'Double Clicked'. Now remove the 'Cancel = True' and notice how the focus IS on the cell that was 'Double Clicked'.

Lewis