Images in cells


Posted by Mark Bryant on June 08, 2000 7:04 AM

I have a problem. I column A I have a list of paths that point to .bmp images. In column B, I want Excel to show the image that the coresponding path in column A points to.


How do I do this?

Thanks

Posted by Mark Bryant on June 12, 0100 7:21 AM

That will work, but I am looking for something more automated. I would like the picture to change when I change the path in column A to another picture.

Thanks,

Mark Bryant

Posted by Ryan on June 12, 0100 11:32 AM

Mark,
You can set up a 'Worksheet_Change' procudure that will get updated links when you change them.



Posted by Ryan on June 11, 0100 3:26 PM

With the 'Control Toolbox' toolbar up, you can select the Image button and click and drag it to where you want it on your page. Right click this and select Properties. Click Picture and select the picture you want. To show the whole picture, Click PictureSizeMode and select
1-fmPictureSizeModeStretch.