how can I cut and paste into the comment box

[Bob W]

I would like to "paste" selected graphic images into the comment box within a
cell in an excel spread sheet

 

[FSt1]

hi
see this site
http://www.contextures.com/xlcomments02.html#Picture

regards
FSt1

 

[Marie]

You have to use the old DOS commands. Highlight what you want to copy and
do a ctrl c then when you get to the comments box point and do a ctrl v. To
cut and paste use ctrl x and ctrl v.

Marie

 

[Gord Dibben]

Marie

Have you tested this theory?


Gord Dibben MS Excel MVP

 

[Marie]

Yes, many times.

Marie

Have you tested this theory?


Gord Dibben MS Excel MVP

 

[Dave Peterson]

And it works with images?

Yes, many times.

 

[Marie]

I used the company logo which is a .jpg.

And it works with images?

 

[Dave Peterson]

I can insert a picture into the comment using the techniques that Debra
Dalgleish documents:
http://contextures.com/xlcomments02.html#Picture
http://www.contextures.com/xlVideos01.html#CommentPicture

But I can't just copy a picture from the worksheet and use ctrl-v to paste into
the comment.

Can you share the steps how do you do it?

 

[Marie]

Highlight what you want to copy and
do a ctrl c then when you get to the comments box point and do a ctrl v.

 

[Dave Peterson]

I inserted a picture onto the activesheet.
I selected that picture and did ctrl-c
I selected a cell
Insert|comment
I hit ctrl-v and got a beep.

I used xl2003 for my tests.

Highlight what you want to copy and
do a ctrl c then when you get to the comments box point and do a ctrl v.

 

[Marie]

I owe you and this discussion board my most profound apologies. It's been
a couple of years since I've done comments but I would have sworn it worked.
Maybe it was only in 2000? You say you can't get it to work in 2003 and I
just tried everything I could think of in 2007.

I'm so sorry I mis-lead everyone. I know I could do this before. It will
drive me nuts until I remember how.

Marie

 

[Dave Peterson]

Not a problem (but I feel better <vbg>).

Maybe you actually added a picture using the technique that Deb shared.

Or added a picture to an image in userform via ctrl-v in that image's picture
property in the property window???

I owe you and this discussion board my most profound apologies. It's been
a couple of years since I've done comments but I would have sworn it worked.
Maybe it was only in 2000? You say you can't get it to work in 2003 and I
just tried everything I could think of in 2007.

I'm so sorry I mis-lead everyone. I know I could do this before. It will
drive me nuts until I remember how.

Marie

 

[Gord Dibben]

Not a problem (but I feel better <vbg>).

As do I<g>

Marie

Keep us posted if you figure out how it used to work.


Gord