software

Can a small GIF or JPG image be stored inside of a cell, or somehow
otherwise associated with it?
Many Thx--
tx12345
------------------------------------------------------------------------
tx12345's Profile: www.excelforum.com/member.php...oamp;userid=24776
View this thread: www.excelforum.com/showthread...hreadid=502228There are a couple different ways you could do this. The first would be to
select quot;Insertquot; from the menu bar and then quot;Picturequot;, then quot;From Filequot;.
Select your GIF or JPG and then resize and place on your sheet where you
want. If you right-click on that picture, and then select quot;Format Picturequot;
then go to the quot;Propertiesquot; Tab, you can set it to move with cells. Thus it
won't really be associated with any particular cell, but its positioning will
stay relative to the cell you've place it on.

The second method would be to insert a Comment into the cell. Select
quot;Insertquot; from the menu bar, then quot;Commentquot;. This creates a little balloon
window that appears whenever you move the mouse over that cell. Then go back
to the quot;Insertquot; menu and select quot;Edit Commentquot;. Delete any text that is in
the Comment Window then click the outer edge of the comment (so you are no
longer editing the text within). Then right-click the edge and select
quot;Format Commentquot;. Then select the quot;Colors and Linesquot; Tab and for Fill Color
choose quot;Fill Effects...quot; Then select the quot;Picturequot; tab and choose your
picture file.

HTH,
Elkar

quot;tx12345quot; wrote:

gt;
gt; Can a small GIF or JPG image be stored inside of a cell, or somehow
gt; otherwise associated with it?
gt;
gt;
gt;
gt; Many Thx
gt;
gt;
gt; --
gt; tx12345
gt; ------------------------------------------------------------------------
gt; tx12345's Profile: www.excelforum.com/member.php...oamp;userid=24776
gt; View this thread: www.excelforum.com/showthread...hreadid=502228
gt;
gt;


The cell comment idea was perfect.

Many Thx!--
tx12345
------------------------------------------------------------------------
tx12345's Profile: www.excelforum.com/member.php...oamp;userid=24776
View this thread: www.excelforum.com/showthread...hreadid=502228
I had another related question

I can manually get the pic into the comment but when I try to use a
macro to automate the process it keeps getting hung up. I recorded the
following in the exact order:Code:
--------------------

Sub adpic()

Range(quot;M9quot;).AddComment
Range(quot;M9quot;).Comment.Visible = False
Range(quot;M9quot;).Comment.Text Text:=quot; :quot; amp; Chr(10) amp; quot;quot;
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.RGB = RGB(0, 0, 0)
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 255)
Selection.ShapeRange.Fill.BackColor.SchemeColor = 80
Selection.ShapeRange.Fill.UserPicture quot;C:\1m.jpgquot;

End Sub
--------------------but it keeps getting hung up heCode:
--------------------
Selection.ShapeRange.Fill.Transparency = 0#
--------------------when I try to execute the macro. Have any ideas?Thx--
tx12345
------------------------------------------------------------------------
tx12345's Profile: www.excelforum.com/member.php...oamp;userid=24776
View this thread: www.excelforum.com/showthread...hreadid=502228