Pointing an image to a Named range rather than a pic file

[mmcginn]

Hi,

I have a macro that adds an Image(ActiveX Control) to a sheet.

Rather than pointing this towards a picture I would like to point it towards a named range therefore giving me a livefeed to a range of cells.

I have been trying to modify the following line without result. I would like to replace the file path with a named range.I have no idea how to do this or if it is possible.

Worksheets("Sheet1").Image1.Picture = LoadPicture("C:\Users\txi\Pictures\pool.gif")

Thanks

 

[Andrew Poulsom]

Sorry, LoadPicture expects a reference to a file on disk.

What you can do is copy a range of cells, then hold down Shift and choose Edit|Paste Picture Link. You will get a linked picture and you can chage what it refers to by editing the formula in the Formula Bar. The reference can be a named range.

 

[RandyKelly19]

I don't know much about VBA, but I know the indirect function allows you to point to another cell that could contain the image link. Maybe that'll help some

 

[energman58]

Sorry are you trying to get a picture of some cells elsewhere on your spreadsheet or somewhere to appear so you can see a live version of how they change? If so just copy your cells in teh nomal way. Then in the spreadsheet where you want it to appear you go to home - paste -as picture- as picture link and it is done. I imagine you could include this as part of some VBA if you needed to by using the macro recorder but i absolutely have no idea what the syntax would be.

 

[mmcginn]

Sorry are you trying to get a picture of some cells elsewhere on your spreadsheet or somewhere to appear so you can see a live version of how they change?

Exactly. As the range changes I want it reflected in the Pic Object

 

[energman58]

In that case just select the cells you want to see the "live" picture of and copy them in the normal way. Select where you want the picture to appear in your WB. Then click Paste in the Home Tab (in 2007) - then at the bottom of the menu you get select "As Picture" and then on teh next menu select Paste Picture Link. That will insert a "live" view of the original cells in the new place which will update as the cells change.

In older versions of Excel the same functionality is available through Shift&Edit - Paste Picture Link