I am new to using VBA and not really sure how to accomplish what I want. Please see attached example.
In sheet1 I have a list of IDs. When I click on the cell for the Note column, I would like for a popup box to display the note from sheet2.
For example, in sheet1 the ID in A2 is 1. If I click on C2 I want the note from sheet2 C2 to appear in a pop up box (in this example it would be "apple").
I want this to change dynamically so that you could sort by the IDs or other information (for example "color") and always get the correct note - this is why I think vlookup is appropriate.
Additionally, I want new IDs to be able to be added and the note popup function would still work. For example, if ID 11 was added in sheet1 and sheet2, I could click on C12 in sheet1 and return the associated note.
Please let me know if anything is not clear. Thanks in advance!!
In sheet1 I have a list of IDs. When I click on the cell for the Note column, I would like for a popup box to display the note from sheet2.
For example, in sheet1 the ID in A2 is 1. If I click on C2 I want the note from sheet2 C2 to appear in a pop up box (in this example it would be "apple").
I want this to change dynamically so that you could sort by the IDs or other information (for example "color") and always get the correct note - this is why I think vlookup is appropriate.
Additionally, I want new IDs to be able to be added and the note popup function would still work. For example, if ID 11 was added in sheet1 and sheet2, I could click on C12 in sheet1 and return the associated note.
Please let me know if anything is not clear. Thanks in advance!!