Results 1 to 1 of 1

Thread: Solved! How do I change color for individual character within cell comment using VBA?

  1. Jun 13th, 2006, 09:51 AM #1
    bongobongo
    bongobongo is offline

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    14

    Solved! How do I change color for individual character within cell comment using VBA?

    Hi.

    I have with VBA inserted one or more lines into a cell comment.

    How do I change the color for the first character in each line using
    VBA, each of the first characters will have different colors.

    Is this possible?..... ... example code please.

    Got the solution:

    ActiveCell.Comment.Shape.TextFrame.Characters(1, 1).Font.ColorIndex = 4
    Last edited by bongobongo; Jun 13th, 2006 at 11:12 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width