Add Pop-up Comment/Note Based on Value

wborlando

New member
Joined
Jun 8, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Hi,

I'm working on a spreadsheet with a formula that returns a "Yes" from a list of employees of those employees who received letters. The list is on a different sheet within the workbook, the list also includes information on the description of the letter. I'm trying to create a pop-up comment on the spreadsheet with the formula that has the "Yes" for the pop-up to show the description of the letter for that specific employee. In other words, if the cell has a yes, I want to show the description of the letter as a pop-up comment for that specific person. However, it may be from two different cells within the sheet for that same employee.

I'm not sure if that is something I could add to the formula I already have, or if that's something I will need to do on VBA and if so, I have no clue how to start it.

Thank you.
 
Code:
Option ExplicitPrivate Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
        Select Case Target.Value
        Case "YES"
                MsgBox "Entered YES"
        Case "NO"
                MsgBox "Entered NO"
        End Select
    End If
End Sub
 
Back
Top