Skip to content
This repository has been archived by the owner on Apr 22, 2020. It is now read-only.

How to use Google Code Prettifier to VBA macro in Microsoft Excel ? #599

Open
rediffusion opened this issue Aug 8, 2019 · 0 comments
Open

Comments

@rediffusion
Copy link

rediffusion commented Aug 8, 2019

Hi, how are you? 馃檪
I have some VBA macro for "Inserting Note" in Microsoft Excel. I want this prettifier to be inserted in my macro for creating a note with highlighting, is it possible (Interested in highlighting such as on StackOverflow)?

08-08-2019 18-56-19

Sub Special_Note_White()
Dim myComm As Comment
  If Not ActiveCell.Comment Is Nothing Then
    If MsgBox("The cell already contains a note, delete?", 4) - 7 Then
      ActiveCell.Comment.Delete
    Else: Exit Sub
    End If
  End If

Set myComm = ActiveCell.AddComment
    With myComm.Shape
      .Height = 110
      .Width = 200
      .AutoShapeType = 1
      .Fill.ForeColor.SchemeColor = 1
      .Line.ForeColor.RGB = RGB(255, 0, 0)
      .DrawingObject.Font.Name = "Consolas"
      .DrawingObject.Font.FontStyle = "normal"
      .DrawingObject.Font.Size = 8
     End With
      'Emulate the choice of "Edit Note".
       SendKeys "+{F2}"
End Sub
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant