Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    COMMENT (MS EXCEL 2003)

    When using the comment it always comes up in FONT 8 can I change the default on that to 10?
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: COMMENT (MS EXCEL 2003)

    Only by changing the Windows display settings for the ToolTip. You can however use code to insert a comment with any formatting you like. For example:
    <pre>Sub AddMyComment()
    Dim rngCell As Range
    For Each rngCell In Selection
    With rngCell
    .AddComment Application.UserName & ": " & vbLf
    With .Comment
    With .Shape
    With .TextFrame
    .HorizontalAlignment = xlCenter
    .VerticalAlignment = xlCenter
    .ReadingOrder = xlContext
    .AutoSize = False
    With .Characters.Font
    .Name = "Arial"
    .Size = 10
    End With
    End With ' .TextFrame
    With .Fill
    .Visible = msoTrue
    .Solid
    .ForeColor.SchemeColor = 47
    .Transparency = 0#
    End With ' .Fill
    With .Line
    .Weight = 0.75
    .DashStyle = msoLineSolid
    .Style = msoLineSingle
    .Transparency = 0#
    .Visible = msoTrue
    .ForeColor.SchemeColor = 53
    .BackColor.RGB = RGB(255, 255, 255)
    End With ' .Line
    .AutoShapeType = msoShapeRoundedRectangle
    End With ' .Shape
    .Visible = True
    End With ' .Comment
    End With ' rngCell
    Next rngCell
    End Sub

    </pre>

    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMMENT (MS EXCEL 2003)

    Thank you, that is amazing. I tried the comment format and it showed it was on 10 but when I start a comment it is still on 8 ? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMMENT (MS EXCEL 2003)

    Thanks Rory, as usual, logging into Woody's lounge throws up something useful!!

    2 questions though.....

    How do you adjust the starting size of the comment?
    Can the 'comment added date' be auto filled? alongside application.username.

    Also, whilst I think of it, where can I find the 'numeric' vba colour pallette??

    Thanks

    Nathan

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: COMMENT (MS EXCEL 2003)

    Excel uses a customizable palette of 56 colors for the font and fill color of cells, and for the line and fill color of charts. See Sample Visual Basic code to create a color index table in Excel.

    The color of comments, can be any of the 16777216 colors supported by Windows.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: COMMENT (MS EXCEL 2003)

    To set the size of the comment, set the Width and Height of its Shape (in points, where 72 points = 1 inch)

    To add the current date/time to the username, change the line
    <code>
    .AddComment Application.UserName & ": " & vbLf
    </code>
    to (for example)
    <code>
    .AddComment Application.UserName & " (" & Format(Now, "mm/dd/yyyy hh:nn AM/PM") & "): " & vbLf
    </code>
    You can, of course, use a different format.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: COMMENT (MS EXCEL 2003)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>don't you mean "hh:<font color=red>mm</font color=red>?

    Steve

  8. #8

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: COMMENT (MS EXCEL 2003)

    Both will work. You can use n or nn for minutes to avoid confusion with m or mm for month, but adjacent to a colon : m and mm will be interpreted as minutes.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: COMMENT (MS EXCEL 2003)

    Good one! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  11. #11
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMMENT (MS EXCEL 2003)

    Could'nt resist......

    :-)

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: COMMENT (MS EXCEL 2003)

    You have to use that code every time you create a comment - it does not change the default comment style. You can assign it to the standard 'Insert->Comment' menu item if you wish.
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: COMMENT (MS EXCEL 2003)

    That must be new(er). I tested it in XL 97 and it put the literal "nn" in the time. I did not test in XL2002 (the version I have on another computer)

    Steve

  14. #14
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMMENT (MS EXCEL 2003)

    Hi R J B P

    There are some good tips on comments on the Contextures web site http://www.contextures.com/xlcomments02.html , hope these are useful

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  15. #15
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMMENT (MS EXCEL 2003)

    Nathan, I like the questions and I could sure learn something from you people <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •