June 14th, 2003, 03:11 PM
Excel Comment Box in Data Validation List
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
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