Results 1 to 10 of 10

Excel Macro to Insert a Comment and add a Picture to the Comment

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-14-2016
    Location
    Brookland, Arkansas
    MS-Off Ver
    2007,2021
    Posts
    132

    Excel Macro to Insert a Comment and add a Picture to the Comment

    Hello so I am trying to do what the title says. But I have no experience with the VBA coding side of excel

    I've gotten as far as this,

    Sub Pic()
    '
    ' Pic Macro
    '
    
    '
        Dim myRange As Range
    Set myRange = Selection
        myRange.AddComment
    
    End Sub
    This creates a totally blank comment. Past here I'm stuck. I have the process below for how to get to the option I want only using keys, but when I try to "record macro" it doesn't pick up those key strokes. Can anyone help me with how to get where I'm trying to go via a macro/VBA coding?

    1) Press Shift+F2 to insert a new comment
    2) press esc ONCE to exit text space but still have comment selected
    3) Press shift+F10 to open the right click menu
    4) press O to open the format comment menu
    5)press C to get to the colors and lines menu
    6) press tab once to get to the color selelection
    7) press enter to open the color selection
    8) press tab 5 times to get to the fill effects
    9) press enter to open the fill effects
    10)press control+tab 3 times to get to the picture menu
    11) press tab once to get to the select picture option
    12) press enter to open the select picture option
    Last edited by TheMechEngineer; 07-12-2019 at 12:05 PM.
    Who needs a life when you have Excel.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with a macro to insert a picture into a comment
    By mhewett in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 12:22 PM
  2. Insert specific picture into comment Macro help!
    By jarednz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2011, 10:01 PM
  3. Macro: Insert Comment with Picture
    By Screamer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2009, 12:45 PM
  4. [SOLVED] How do I insert a picture within an Excel comment box?
    By Roy White in forum Excel General
    Replies: 1
    Last Post: 09-23-2005, 09:05 AM
  5. [SOLVED] EXCEL: Is there a way to insert a picture into a comment?
    By Max in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 07:05 PM
  6. EXCEL: Is there a way to insert a picture into a comment?
    By Max in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 09:05 AM
  7. EXCEL: Is there a way to insert a picture into a comment?
    By m.l.v. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. EXCEL: Is there a way to insert a picture into a comment?
    By m.l.v. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1