Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic cell comment
Subject: Adding a cell comment with a value from a diferent cell and on a
different sheet Is there a way to add a comment to a cell which the comment contains the value from a different cell. Scenario: I have cells which have the days of the week abbreviated (Su, Mon, Tues, etc) These cells have a narrow width just enough for the abbreviation. I would like to add a comment to that cell which the comment would be: Sunday, August 27th, 2006 Screenshot: http://img172.imageshack.us/img172/1...ethoursmu6.jpg The 09/02/06 is the week ending date (Saturday for week 1). The value (week ending date) can change depending on what start date the user indicates on another sheet. What it would look like: http://img101.imageshack.us/img101/8...thours2fc2.jpg Thanks in advance for any help!!! ADK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic cell comment
Herr is a small macro that takes the value from Sheet1 cell A1 and puts it in
a comment in Sheeet2 cell B2: Sub Macro1() Dim r1 As Range Dim r2 As Range Set r1 = Worksheets("Sheet1").Range("A1") Set r2 = Worksheets("Sheet2").Range("B2") r2.AddComment r2.Comment.Visible = False r2.Comment.Text Text:=r1.Value End Sub -- Gary''s Student "ADK" wrote: Subject: Adding a cell comment with a value from a diferent cell and on a different sheet Is there a way to add a comment to a cell which the comment contains the value from a different cell. Scenario: I have cells which have the days of the week abbreviated (Su, Mon, Tues, etc) These cells have a narrow width just enough for the abbreviation. I would like to add a comment to that cell which the comment would be: Sunday, August 27th, 2006 Screenshot: http://img172.imageshack.us/img172/1...ethoursmu6.jpg The 09/02/06 is the week ending date (Saturday for week 1). The value (week ending date) can change depending on what start date the user indicates on another sheet. What it would look like: http://img101.imageshack.us/img101/8...thours2fc2.jpg Thanks in advance for any help!!! ADK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
Create a condition and allows a automatic comment | Excel Worksheet Functions | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |