How do i create a comment in excel which shows up only when i click on it,
normally when you insert a comment in excel it shows up as a red triangle, i don't want this but i want a comment box to appear when i click on the cell
How do i create a comment in excel which shows up only when i click on it,
normally when you insert a comment in excel it shows up as a red triangle, i don't want this but i want a comment box to appear when i click on the cell
Which version of Excel are you using? - this link should help you lose what you "do not want"
As for what you "do want" ,try this:
Put this code into each worksheet module - the first line must be at the top of the module before the subs
Please Login or Register to view this content.
Last edited by kev_; 04-18-2017 at 05:04 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
VBA to avoid the triangles at workbook level
Place in ThisWorkbook module:
then save, close and reopen the filePlease Login or Register to view this content.
Note I have tried the first version by kev_:
File--> options--> advanced --> however that removes all triangle comments, for example on my spreadsheet I want the triangle comments to show for c2, d2 etc. on the activity 1 spreadsheet that is attached.
I developed the attached spreadsheet with a colleague a few years ago, and I cannot recall needing to add any code, perhaps my colleague did and I was not paying attention. I work in a school and it is basically a coursework mark sheet. When you are on activity 1 worksheet and click on cell i3 & j3 a note appears with the student’s grade, how can I do the same thing for activity 3 cell j2 & K2?
Thank you in advance.
In your post you did not specify that you only wanted red triangles to be removed some of the time
A workaround would be to remove the triangles and then use conditional formatting to highlight the cell in a different way for those cells where you want to retain a marker.
Unfortunately I do not think you can pick and choose with this little blighter
- I thinks its a one option deal
- the red triangle is either there for all cells or not there for any cells
- I will research this when I have time later today - there may be some little trick I do not know about.
Your reply suggests that the comments themselves disappeared - that should not be the case - you should be able to remove the triangles and retain the comment - PLEASE CLARIFYIt may be that the comment is not displaying when you hover over the cell. Select the cell and click on Edit Comment - I am pretty certain the comment is still present.however that removes all triangle comments
- that can be fixed with a macro to display the comment when you select the cell
thanks
Last edited by kev_; 04-19-2017 at 04:14 AM.
Sorry for the confusion.
Please look at the attachment called Coursework Unit 2 Grade for forum.xlsx, the worksheet called Activity 1 is complete and it is my template.
Worksheet 2 which is called Activity 3 is the one I need help on, on J2 and K2 i want to leave a comment when the user clicks on this cell.
Thank you.
Where is your attachment? It seems to have disappeared....
click on Reply, Go Advanced, then scroll down to Manage Attachments
ManageAttachments3.jpg
the attachment is in thread #4
oh - I was looking for it on post#6 - thanks
And the mystery is solved
- Cell Comments and Data Validation Messages may look similar but they are different beasts
What you are wanting to do is done via Data validation
Select cell I3 in sheet Activity1 and then click on Data Validation and all will become clear (hopefully )
Red triangles only appear when cells have Comments as in cell H2
DATA VALIDATION MESSAGES:
NonComment.jpg
CELL COMMENTS:
Comment.jpg
Last edited by kev_; 04-19-2017 at 01:48 PM.
Thank you
I will give this a go, i have a feeling this is how to do it.
I recall something similar a very long time a go when it was completed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks