I refer to a great post (Interactive Dashboard in Excel using Hyperlinks) I saw from Chandoo and thought it can be relevant here - URL: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
I have posted this same thread in Ozgrid but I do suspect what I was asking was expected too much.
My intent is this, though: If you can please just help me get started and give advice. I am very willing to try it myself and would be happy (and proud :D) to post my progress and final solution back here again. I am relatively very new to event handling and this will be my first time embarking on this path. Neither do I have an example page as I am really stuck in planning and starting.
This was my question:
"I want to display jpeg images of 100's of garments listed in various sheets. With Winding font i have created a triangle/down arrow in each cell of say column G (like Chandoo has done in his post I mentioned above) where Column H has a description of the garment and each cell in column C has a unique garment identifier number, say "W16 ISO 018". The images will be stored in a subfolder e.g. c:\WorkbookFolder\Images with each name the same as the unique garment identifier number. The idea is to hover over the down arrow of a cell in column G which will pop up a picture of the garment and have it shown as a size of say 5cm by 10 cm. Moving the mouse off the link will let the picture disappear again.
I don't know how to go about this. Can you please assist? Garments will be added as it is created."
Just creating an ordinary hyperlink will not work, because this does not display the image in the Excel window but in an image viewer. Also I do not want to manually create a hyperlink to each row as new data will be added by the user. Alternative suggestions is also very welcome...if I can just get to do something that will work well please.
Thank you in advance for any advice or suggestions...
I have posted this same thread in Ozgrid but I do suspect what I was asking was expected too much.
My intent is this, though: If you can please just help me get started and give advice. I am very willing to try it myself and would be happy (and proud :D) to post my progress and final solution back here again. I am relatively very new to event handling and this will be my first time embarking on this path. Neither do I have an example page as I am really stuck in planning and starting.
This was my question:
"I want to display jpeg images of 100's of garments listed in various sheets. With Winding font i have created a triangle/down arrow in each cell of say column G (like Chandoo has done in his post I mentioned above) where Column H has a description of the garment and each cell in column C has a unique garment identifier number, say "W16 ISO 018". The images will be stored in a subfolder e.g. c:\WorkbookFolder\Images with each name the same as the unique garment identifier number. The idea is to hover over the down arrow of a cell in column G which will pop up a picture of the garment and have it shown as a size of say 5cm by 10 cm. Moving the mouse off the link will let the picture disappear again.
I don't know how to go about this. Can you please assist? Garments will be added as it is created."
Just creating an ordinary hyperlink will not work, because this does not display the image in the Excel window but in an image viewer. Also I do not want to manually create a hyperlink to each row as new data will be added by the user. Alternative suggestions is also very welcome...if I can just get to do something that will work well please.
Thank you in advance for any advice or suggestions...