I have a column which contains a list of chemicals.

I use vlookup to get data for the chemicals such as density, flash point and
boiling point etc.

What i would like is for a comment box to become available for each
chemical, containing the vlookup data so that the chemical properties are
readily available when the curser goes over each chemical.

Is this possible and would it be possible for the comment box only to become
available if a chemical is actually in the column?

Can anyone help?

Thanks,

Roger