Adding Pop Up Comments to Excel

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!

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.

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.