Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
Put the comment in both cells.
MASIH wrote: HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
DAVE
THANK YOU, BUT I WAS REFERING TO ONE COMMENT BOX WITH SAME COMMENTS BIT ATTACHED TO MORE THAN ONE CELL, TO AVOID THE CLUTTER ON THE WORK SHHET. MASIH "Dave Peterson" wrote: Put the comment in both cells. MASIH wrote: HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
That is not possible in Excel.
"MASIH" wrote: DAVE THANK YOU, BUT I WAS REFERING TO ONE COMMENT BOX WITH SAME COMMENTS BIT ATTACHED TO MORE THAN ONE CELL, TO AVOID THE CLUTTER ON THE WORK SHHET. MASIH "Dave Peterson" wrote: Put the comment in both cells. MASIH wrote: HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
Hi,
Typing in ALL CAPS is consider SHOUTING on the INTERNET. If you want to do this the best you can do is expose the comment when selecting more than one cell. But note there will be not indicator on any of the cells other than the primary cell. Would that do? Also, will all the cells that you want to trigger the comment be within the viewable area of the primary cell? If not just exposing the comment won't be enought. Also, since the only thing that shows in a sheet with comments are the red comment indicator at the top right corner of the cell, and these don't print, I'm not sure what "clutter" you are talking about. Please elaborate. -- If this helps, please click the Yes button Cheers, Shane Devenshire "MASIH" wrote: HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL
Hi,
1. In the sheet object where you want to have a shared comment add the following code Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim isect As Range Set isect = Application.Intersect(Target, Range("A1,C1,E1")) If Not isect Is Nothing Then Comment1.Show End If End Sub 2. Create a UserForm named Comment1 and add a label named lblComment and an OK button. 3. Add the following code to the UserForm: Private Sub OK_Click() Unload Me End Sub Private Sub UserForm_Initialize() Me.lblComment.Caption = Range("A10").Comment.Text End Sub 4. Add a comment into A10 of the sheet. The code is designed to launch the userform with the comment displayed whenever any lf the specified cells are selected A1, C1, E1. -- If this helps, please click the Yes button Cheers, Shane Devenshire "MASIH" wrote: HOW DO I SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What does Show Ink in Excel, Review Tab, comment, do? | Excel Worksheet Functions | |||
How to show original comment in cell when using Vlookup in Excel? | Excel Worksheet Functions | |||
Show Comment when in the cell | Excel Worksheet Functions | |||
Excel should show Comment box even if adjacent columns are hidden | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) |