Question

Locked

Adding Pop Up Comments to Excel

By 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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Not natively

by Tig2 In reply to Adding Pop Up Comments to ...

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!

Collapse -

Not exactly what you want, but it works

by ThumbsUp2 In reply to Adding Pop Up Comments to ...

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.

Collapse -

Sure...easy too

by kenneth.johnson9 In reply to Adding Pop Up Comments to ...

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.

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums