LinkBack URL
About LinkBacks
Say I have a sheet that displays a warning in a cell based on some criteria. I want to know how to display a comment only when the warning displays.
Ive attached an example.
WarningComment-Example.xlsx
Say I have a sheet that displays a warning in a cell based on some criteria. I want to know how to display a comment only when the warning displays.
Ive attached an example.
WarningComment-Example.xlsx
Hi -
Excel has a specific annotation you can attach to any cell called a "Comment". You can add them by selecting a cell, right mouse button click, and select Insert Comment from the popup menu. If you go to the Review tab at the top of the sheet, you can select Show/Hide Comment to make ALL comments appear or disappear throughout the whole worksheet. I believe this is a sheet property and not comment by comment. To manipulate this sheet property I think would take either a macro or some VBA programming. I don't get the feeling that is what you are trying to do. Are you just trying to add some extra message if a cell has a WARNING indication?
A quick fix might be to go to cell E3, say and write the following function:
=IF(D3="WARNING","My Comment","")
That would allow you to add some message if one of the cells has a warning. Perhaps I don't understand fully what you are trying to do.
Hope that helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Thanks for the help. I appreciate it.Originally Posted by loginjmor
That would be the easier way of doing it. But I need a comment that only the user sees, as a pop-up box.
I think you are correct about the VBA programming. Ive tried searching all over Google, and all I keep coming up with is VBA examples that are in the same ballpark as what Im trying to do, just not similar enough for me to adapt them.
I wonder, should I ask this question again in the VBA forum?
Yes, that sounds like a VBA post to me. Good luck.
If you want the warning comment to show up when the user enters a value in column B, you could use Data Validation to do this. (See attachment)
Select your range (i.e C3:C12) > Data Validation> Custom
=C3=B3
Go to "Error Alert" tab, Information (you could use Warning also)
Enter your text.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I still dont think thats what Im trying to do, but thanks for the tip.
Last edited by Science-Guy; 04-16-2013 at 09:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks