Picture?

[DougDR]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Dear Mike/ or anyone

Thank you for your support. I would like to ask a number of questions but for now just one.
Your trick 42 shows how to put pictures into the comment of a cell. It was based on a single cell.
I have a need to have it happen row by row based on a part number which is also the Folder name in which the pictures are placed and based on the picture name, both of these are in the row in question. The picture needs to appear in the comment of the description cell in the same row. There for in a row you have the part number ##-##-NNNN and the picture name @@@@@.jpg, the folder where the picture is E:\My Documents\####\######\##-##-NNNN

Hope you can help

 

[DougDR]

Please someone can you help

 

[DougDR]

Please .... Please Picture?

Please .... Please can someone please help.

"Dear Mike/ or anyone:wink:

Thank you for your support. I would like to ask a number of questions but for now just one.
Your trick 42 shows how to put pictures into the comment of a cell. It was based on a single cell.
I have a need to have it happen row by row based on a part number which is also the Folder name in which the pictures are placed and based on the picture name, both of these are in the row in question. The picture needs to appear in the comment of the description cell in the same row. There for in a row you have the part number ##-##-NNNN and the picture name @@@@@.jpg, the folder where the picture is E:\My Documents\####\######\##-##-NNNN

Hope you can help"

 

[GlennUK]

Re: Please .... Please Picture?

Explain what trick 42 is, for those of us who haven't seen it.

 

[SuperFerret]

Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA

So you have a spreadsheet with all the information (be handy to know which column has the Part Number and which column contains the Picture name)

Are you wanting a macro to loop through all the worksheet and insert Picture comments for each row? According to the information already contained in each row?

 

[DougDR]

Yes yes

I have a stock number in ColumnE ... a description in ColumnK and a picture name (name.jpg) in ColumnBH. I would love it if the comment in the description could auto get a picture. there are times when the picture name is not yet inplace. All the pictures are in a folder with the same name as the "stock number". Boy I hpoe you can help, I will be very greatfull.

Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA

So you have a spreadsheet with all the information (be handy to know which column has the Part Number and which column contains the Picture name)

Are you wanting a macro to loop through all the worksheet and insert Picture comments for each row? According to the information already contained in each row?

 

[DougDR]

Re: Please .... Please Picture?

Hi GlennUK
I just watched it and it allows you to place a picture in the comment of a cell which has a validation list attached. Then as you change the selection a new picture jumps up related to the selection. Boy if I explained that right I will be surprised
http://www.mrexcel.com/forum/member.php?u=5690

 

[SuperFerret]

Perhaps something like this:
http://www.ozgrid.com/forum/showthread.php?t=42697&p=215416#post215416
(adjusted to fit your worksheets of course)

 

[GlennUK]

Re: Please .... Please Picture?

Hi GlennUK
I just watched it and it allows you to place a picture in the comment of a cell which has a validation list attached. Then as you change the selection a new picture jumps up related to the selection. Boy if I explained that right I will be surprised
http://www.mrexcel.com/forum/member.php?u=5690

I will watch it when I'm logged on somewhere that'll allow that ( at home, if I have time ) ... sounds interesting. I've done a lot of things with pictures over the years, but never that one.

 

[DougDR]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->
Oh boy. I feel like a bit of a fool. I am sure that what you propose will work ..... if only I knew how to adjust it. I am fairly good with Excel but not very good with VBA.