Results 1 to 2 of 2

Thread: Add Pop-up Comment/Note Based on Value

  1. #1
    Neophyte wborlando's Avatar
    Join Date
    Jun 2021
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Add Pop-up Comment/Note Based on Value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    312
    Articles
    0
    Excel Version
    2007
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •