Questions

Adding Pop Up Comments to Excel

+
0 Votes
Locked

Adding Pop Up Comments to Excel

anthony.buchanan
Does anyone know of a way (or any add in) that will allow you to add a pop up to an excel spreadsheet? For example, I want to put a large red star by things I want to note, and then allow the user to click on the star to see a comment. Is that possible? I've tried comments, but can't get that to work correctly. Any suggestions? Thanks
  • +
    0 Votes
    Tig2

    I don't believe that Excel will support a pop-up, even through a macro.

    You can add a star or other graphic to a cell that contains a comment and post an instruction at the sheet header that advises the user to hover over the green triangle that appears in a commented cell for additional information. Secondarily, you can create a hidden column and put your notes there. Mark your notes with a star or other graphic and then narrow the column to display the graphic only. Now create a macro that will open the column on a click to the graphic.

    I believe that you can also set sub-dialogs that are editable on a radio button click but I believe that will depend on the version of Excel you are using.

    Hope this is helpful!

    +
    0 Votes
    ThumbsUp2

    The solution we use isn't exactly what you want. You can't click on the check mark to make the popup appear. However, the COMMENT function works with a mouseover effect. You can put anything into the cell, including a picture of a checkmark (which is what we use) or formulas to do some calculations, and then insert a comment in the cell. When you mouse over the cell, the comment appears all by itself. The cell itself will have a little red triangle in the upper right corner indicating there is something there to reveal.

    +
    0 Votes
    kenneth.johnson9

    You could make a button. Place a picture on the button. Attach code to the button that is similar to this:

    msgbox("Your message here")

    Just that simple. does this help? Lemme know and I can offer alternate options.

  • +
    0 Votes
    Tig2

    I don't believe that Excel will support a pop-up, even through a macro.

    You can add a star or other graphic to a cell that contains a comment and post an instruction at the sheet header that advises the user to hover over the green triangle that appears in a commented cell for additional information. Secondarily, you can create a hidden column and put your notes there. Mark your notes with a star or other graphic and then narrow the column to display the graphic only. Now create a macro that will open the column on a click to the graphic.

    I believe that you can also set sub-dialogs that are editable on a radio button click but I believe that will depend on the version of Excel you are using.

    Hope this is helpful!

    +
    0 Votes
    ThumbsUp2

    The solution we use isn't exactly what you want. You can't click on the check mark to make the popup appear. However, the COMMENT function works with a mouseover effect. You can put anything into the cell, including a picture of a checkmark (which is what we use) or formulas to do some calculations, and then insert a comment in the cell. When you mouse over the cell, the comment appears all by itself. The cell itself will have a little red triangle in the upper right corner indicating there is something there to reveal.

    +
    0 Votes
    kenneth.johnson9

    You could make a button. Place a picture on the button. Attach code to the button that is similar to this:

    msgbox("Your message here")

    Just that simple. does this help? Lemme know and I can offer alternate options.