In Excel My client wants to add comments to their customer names and address list, I have it set up as a look up table that is used on several workseets. I am using data validation, if in the data validation worksheet that contains the list, I can add a comments box, but when selected in the other worksheets with the drop down list to select the name and address, the comment associatated does not show

The question

is there a way to include the associated comment box associated with the name and address list??? in a drop down selection?

I'm a VB newbie, so please be gentle