Hi:

I have set up data validation to choose from a list a pre-defined set of text items. In the list I have also added picture comments. The problem is that when I use data validation, the comments are not copied as well. I wanted to get around copying and pasting comments manually.

Is there any way to copy the comments as well using the data validation method ( or offset) without using vba.

If not, can I override some update function during the validation to add the comments in vba.

My lists are of doors and the comment is a picture of the frame for that specific door.

door 1 description(with comment picture for frame 1)
door 2 description (with " " " " 2)
...

There are about twenty doors and frames which are used hundreds of times over in the worksheet.
Pulling down the specific door from the list and having the associated frame picture show up as the comment is perfect for our use.

I realize that this seems more suited for Access, but everyone else will only use excel.

Any help would be appreciated

lab