Application.CutCopyMode = False intellisense doesn't show this option

[taurean]

Sometimes, I wonder why this particular option is not shown by intellisense though valid. Macro recorder also picks it fine.

It shows the other two which I have seldom put explicitly xlCut and xlCopy!

 

[Jon von der Heyden]

I believe the reason is that CutCopyMode is written as a Long Integer property; using xlCutCopyMode Enumeration.
Boolean's can still be passed but will be treated as Long Integers (True=-1; False=0)

You can test this by creating a dummy property. I've wacked this in the ThisWorkbook module.

Private mxlCutCopy As XlCutCopyMode

Public Property Get CutCopyExample() As XlCutCopyMode
    CutCopyExample = mxlCutCopy
End Property

Public Property Let CutCopyExample(ByVal xlCutCopy As XlCutCopyMode)
    mxlCutCopy = xlCutCopy
End Property

Sub test()
    Me.CutCopyExample = False
    Debug.Print Me.CutCopyExample
End Sub

So if you play around with it you will see that intellisense only offers xlCut and xlCopy because those are the only two values in the xlCutCopyMode enumeration. But if you test True/False you will see -1/0 respectively written out to the immediate window.

 

[taurean]

Yes that sure seems to be the case. But shouldn't it be shown by intellisense? It is minor annoyance.

 

[Jon von der Heyden]

The point I make is that it can't be shown because of the enumeration. Unless they were to add xlTrue (-1) and xlFalse(0) to the enumeration.