Muokkaa

Jaa

Application.CutCopyMode property (Excel)

  • Artikkeli

Returns or sets the status of Cut or Copy mode. Can be True, False, or an XLCutCopyMode constant, as shown in the following tables. Read/write Long.

Syntax

expression.CutCopyMode

expression A variable that represents an Application object.

Remarks

Return value Description
False Not in Cut or Copy mode.
xlCopy In Copy mode.
xlCut In Cut mode.
Set value Description
False Cancels Cut or Copy mode and removes the moving border.
True Starts Cut or Copy mode and shows the moving border.

Example

This example uses a message box to display the status of Cut or Copy mode.

Select Case Application.CutCopyMode 
 Case Is = False 
 MsgBox "Not in Cut or Copy mode" 
 Case Is = xlCopy 
 MsgBox "In Copy mode" 
 Case Is = xlCut 
 MsgBox "In Cut mode" 
End Select

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.