Add comments based on certain value with its contents from vlookup result - Excel VBA

[CakzPrimz]

Hi,

I have a list of Disciplines, such as : Civil, Piping, Electrical, etc in Sheets A, from range A1:A8, and I have another Sheets B, which have list of Discipline in columns A and list of Employee's name in columns B and Title in columns C.

Sheets A:
Range A1 value = Civil
Range A2 value = Piping

Sheets B:
Range A2 to A500 = list of Discipline (Civil, Piping, Electrical, etc)
Range B2 to B500 = list of Employee's Name
Range C2 to C500 = list of Employee's Title

How to make a VBA code, so when I double click Range A1 within Sheets A (Civil), then it will add a comment in Range A1 Sheets A, list of everyone who works for Civil Department, based on vlookup on Range A1 value, and the contents of this comments will give me a list of Employee's Name and Employee's Title.

Really appreciate any helps, advices and solutions.

Thanks so much.