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,
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?![]()
Sub Pic() ' ' Pic Macro ' ' Dim myRange As Range Set myRange = Selection myRange.AddComment End Sub
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
Bookmarks