Shortcut key for "new comment" - Excel 365

[henryg]

Shift-F2 is still the shortcut key for inserting a new note (ex comment) but I cannot find a shortcut key for insering a new comment - Alt-RC will do it but nowhere near as easy; and my brain is wired for shift-F2 . Anyone, please?

 

[DRSteele]

There exists a New Comment icon in the All Commands section of the ribbon editor. You can add that to the QAT and it'll always be available.

 

[henryg]

Yes I've done that, but slow by comparison. I'll have to remember alt-rc.

 

[My Aswer Is This]

Why not create yourself a Vba script like this and assign it a shortcut key
If you want it available in all Workbooks put the script in your Personal Workbook.

This script will put a Comment Box in the activecell and provide a few more treats if you want.

Sub Add_Comment()
'Modified  11/9/2018  7:20:16 PM  EST
ActiveCell.AddComment
With ActiveCell.Comment
    .Text "Us"
    .Shape.TextFrame.Characters.Font.Size = 16
    .Shape.TextFrame.AutoSize = True
    .Shape.Fill.ForeColor.SchemeColor = 7
End With
End Sub

 

[My Aswer Is This]

If you want your comment to be different every time try this

Sub Add_Comment()
'Modified  11/9/2018  7:28:16 PM  EST
Dim ans As String
ans = InputBox("Enter Text do you want in comment")
ActiveCell.AddComment
With ActiveCell.Comment
    .Text ans
    .Shape.TextFrame.Characters.Font.Size = 16
    .Shape.TextFrame.AutoSize = True
    .Shape.Fill.ForeColor.SchemeColor = 7
End With
End Sub

 

[ozborni]

Hi, I have been looking for this too, Ctrl+Shift+F2 = new comment