EXCEL Macros to link an image to a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2145046%22%20slang%3D%22en-US%22%3EEXCEL%20Macros%20to%20link%20an%20image%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20document%20that%20I%20use%20to%20create%20an%20Inventory%20Stock%20Report%20from%20MYOB.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%204%20x%20Macros%20used%20in%20this%20document%20that%20let%20you%20hover%20over%20an%20item%20code%20in%20a%20cell%20and%20displays%20an%20image%20(that%20is%20saved%20on%20our%20server%20and%20also%20displayed%20in%20the%20Item's%20Inventory%20card%20in%20MYOB)%3CBR%20%2F%3E1.%20AppendToExistingOnRight%3C%2FP%3E%3CP%3E2.%20ColourChange%20(takes%20the%20.jpg%20from%20being%20visible%20from%20the%20file%20name)%3C%2FP%3E%3CP%3E3.%20InsertComments%3C%2FP%3E%3CP%3E4.%20ResizeAllComments%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%2C%20is%20that%20some%20time%20ago%20we%20changed%20our%20file%20storage%20location%20and%20this%20info%20was%20never%20updated%20within%20the%20Macros.%20I%20have%20tried%20changing%20to%20what%20I%20think%20it%20should%20be%20but%20now%20all%20i%20get%20is%20a%20blank%20box%20(where%20the%20image%20should%20be)%20when%20I%20hover%20over%20a%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20haven't%20had%20much%20experience%20with%20Macros%20so%20unsure%20where%20to%20look%20to%20fix%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2145046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2145684%22%20slang%3D%22de-DE%22%3ESubject%3A%20EXCEL%20Macros%20to%20link%20an%20image%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145684%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F970393%22%20target%3D%22_blank%22%3E%40mtwhite%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20knowledge%20of%20the%20new%20path%20as%20well%20as%20a%20file%20(without%20sensitive%20data)%20with%20the%20existing%20macro%20would%20help%20a%20lot%2C%20that%20one%20could%20present%20you%20with%20a%20reasonable%20proposal%20for%20a%20solution.%3CBR%20%2F%3EKnowing%20the%20Excel%20version%20and%20the%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an excel document that I use to create an Inventory Stock Report from MYOB.

There are 4 x Macros used in this document that let you hover over an item code in a cell and displays an image (that is saved on our server and also displayed in the Item's Inventory card in MYOB)
1. AppendToExistingOnRight

2. ColourChange (takes the .jpg from being visible from the file name)

3. InsertComments

4. ResizeAllComments

 

My issue is, is that some time ago we changed our file storage location and this info was never updated within the Macros. I have tried changing to what I think it should be but now all i get is a blank box (where the image should be) when I hover over a cell.

 

Unfortunately, I haven't had much experience with Macros so unsure where to look to fix this issue.

 

Thanks in advance for any help!

1 Reply

@mtwhite 

The knowledge of the new path as well as a file (without sensitive data) with the existing macro would help a lot, that one could present you with a reasonable proposal for a solution.
Knowing the Excel version and the operating system would be an advantage.


Thank you for your patience and time.


Nikolino
I know that I don't know (Socrates)