Graphics in a Cell Comment
 

Hi

I have a slightly more complicated request. I want to display a student's picture in the comment box accompanying their student numbers.

The pictures are all the same size and type. Picture file names are the same as student's student number.

I know zillltch about programming, VBA etc.

Pictures in a source folder - or can these pictures also be embedded in the Excel workbook. In this case we are talking about 99 students.

Please assist. Much much appreciated.

Andries

Graphics in a Cell Comment
 

Debra Dalgleish covers this request with code and a sample workbook.

http://www.contextures.on.ca/xlcomme...ml#PictureFile

List of pictures in a column with a Comment and picture.

Suggest you re-size pictures before importing them to sheet.


Gord


On Sun, 19 Jan 2014 01:29:25 -0800 (PST),
wrote:

Hi

I have a slightly more complicated request. I want to display a student's picture in the comment box accompanying their student numbers.

The pictures are all the same size and type. Picture file names are the same as student's student number.

I know zillltch about programming, VBA etc.

Pictures in a source folder - or can these pictures also be embedded in the Excel workbook. In this case we are talking about 99 students.

Please assist. Much much appreciated.

Andries