Consulting

Results 1 to 2 of 2

Thread: add a picture to comment

  1. #1
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location

    add a picture to comment

    hello
    i wanted to add a picture to a comment
    [VBA]
    With selection
    .AddComment
    .Comment.Visible = True
    .Comment.Text Text:="moshe ben - avraham:" & Chr(10) & ""
    .ShapeRange.Fill.UserPicture "F:\???''?\???\My Pictures\01-F-B29-S82.jpg"
    End With
    [/VBA]
    what is wrong with my code?
    thanks
    moshe

  2. #2
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    Try this,

    [vba]
    .Comment.Shape.Fill.UserPicture "F:\???''?\???\My Pictures\01-F-B29-S82.jpg"
    [/vba]

    Assumes the file path is valid.
    Cheers
    Andy

Posting Permissions

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