Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Put a photo into a Comment box in Excel 2010

03 Nov 2014   #1
Keirsp

Windows 7. 32bit
 
 
Put a photo into a Comment box in Excel 2010

I have used Excel 2010 to produce a family history chart - works well; 1400 names so far. I use the Comment facility to add a potted history of each person. I would like to use a similar facility to add photos. That is, place cursor over the name cell: see a photo. Remove cursor: photo disappears. I have tried all the usual file types but none will paste into the comment box. Is there a way to convert a photo that will paste, please?


My System SpecsSystem Spec
.
03 Nov 2014   #2
Tookeri

Windows 7 Pro 32
 
 

You can only put text in a comment box, so you'll have to find another solution. If you're familiar with VBA and writing some code there's an example here: Show and hide a picture (vba) | Get Digital Help - Microsoft Excel resource

If not, maybe it's a good time to start learning VBA
My System SpecsSystem Spec
12 Nov 2014   #3
Keirsp

Windows 7. 32bit
 
 
Put a photo into a Comment box in Excel 2010

Hi Tookeri
Thanks for your reply. I have looked at your suggested link, and I can see it would provide what I need, but I'm afraid to say, the code writing baffles me, and as an 80+ PC user, learning from scratch will probably take more time than I can afford!
I guess I need someone to do it for me, at a price, of course!
Thanks anyway.
Keirsp
My System SpecsSystem Spec
.

12 Nov 2014   #4
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

Have you considered creating a hyperlink in an adjoining cell that will allow you to click on the link and bring up a picture of the person? You could actually use the person's name as the text for the hyperlink. The picture could be on the local disk, a network drive or even on a web page. It may not work just by hovering the mouse over it but it's much easier to implement.
My System SpecsSystem Spec
Reply

 Put a photo into a Comment box in Excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Excel 2010 help
I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation. Currently there are 200 unique names in 1st column and of course 200...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Visual Studio 2010 - Make comment out of selection
in dreamweaver there are buttons for dealing with line or text selection for making it commented or not. i lack completely on how to this in visual studio. is there a toolbar or a button for such? what i mean is simply surrounding a text selection without having typing that every time - and...
Software
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App