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

[TheMechEngineer]

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,

Please Login or Register  to view this content.

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

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[TheMechEngineer]

If the execution as a whole is too much to tackle. Would some be able to tell me the coding to simulate a keystroke. For example what is the code I write for excel to think I've pressed "Shift+F2" or "tab" any number of times.

[TheMechEngineer]

There you go, I hope that makes things more clear as to what I've coded so far.

[Pepe Le Mokko]

Thanks, but the tags didn't appear. For some reason the closing tag was misspelled. Did you add them by hand?
Anyway, I changed it for you. In the future just select the code and click # button

(an also don't quote entire posts unnecessarily, they are clutter and make threads hard to read)
Thanks

[Pepe Le Mokko]

This being said, you might find lots of help at https://www.contextures.com/xlcomments03.html

[TheMechEngineer]

Thank you, for correcting it. I didn't add it by hand though, I copied it out off the forum post you linked me. Sorry, as I said before, this side of things is totally alien to me.

[TheMechEngineer]

That was a good article Pepe. From going over it, the results it gives aren't quite what I am aiming for. However, upon further research I found the "SendKeys" command (https://social.technet.microsoft.com...ys-method.aspx) this seems to do what I am asking although when I try to create a dummy macro to test it out to make sure I understand it, the macro errors out. Here is my code

Please Login or Register  to view this content.

[TheMechEngineer]

Please Login or Register  to view this content.

boom

[Leith Ross]

Hello MechEnginner,

Here is a macro that will add a comment and a picture to the active cell. You will need to change the "PicPath" to picture you want in the comment. This macro allows you to easily change the comment properties.

Please Login or Register  to view this content.