Format Cells With Cell Comments

Nov 16, 2006

1)After comparison and no difference between the cells
1.1) If the cell selected is blank then there will not be any color
1.2) Else the cell will be colored GREEN

2)After comparison and there is difference between the cells
2.1) Cells wiill be colored RED

However, my code seems to be unable to execute (1.1) . Pls help to see if there's any thing wrong with my code


For K = 1 To 31
For L = 1 To 29
'Do a comparison of the cells
If StrComp(Array_compare(A, 1), Array_compare(A, 2)) = 0 Then

If IsEmpty(Array_compare(A, 1)) Then
Sheets(3).Select
Cells(K, L) = Array_compare(A, 1)

Else
Sheets(3).Select .................

View 9 Replies


ADVERTISEMENT

Move Cell Comments With Cells

May 3, 2008

I have a cell comment on a series of columns and want to show only one column at a
time. For this reason I hide the ones not used, but the cellcomment doesnt move and
is still at the original place. How I move the comment when the original colums between are hidden ?

View 2 Replies View Related

Transfer Cells Values To Cell Comments

Aug 22, 2007

I have a report where, month in month out, i have to append columns on the right, to give a Year to date figure. Now there are many rows with different numbers but one of the columns is call [NOTES]. This is where the user can provide commentry on the weekly figures.

Now whats getting annoying is i have to copy this commentry and then create a comments box then paste the text in there and finally, hide the comment.

So what i want to be able to do is be able to Copy the cell, then, have a right click menu button saying "Paste As Comment", so it paste the selected cells contents into a comment and hides it.

View 9 Replies View Related

Store Values Of Cells With Cell Comments

Jul 1, 2008

I have a worksheet where some cells contain a comment. I don't know beforehand how many of those cells are present, nor their address. I want to write a macro that stores the values of only the cells that contain a comment into an array (of course the size of the array is not known beforehand). This should be done by scanning through those special cells in a given order (by rows, by columns, whatever).

View 4 Replies View Related

Prevent Copy / Paste Cells With Comments Or Allow Paste But Do Not Paste Comments

Feb 4, 2014

How would you prevent the copy/paste of cells that have comments?

Also, how would you allow cells with comments to be copied and pasted without pasting the comments?

I also have an aside question about the forum advanced search. When searching for multiple search words, how would you type the search to include all words, for example, "prevent" & "paste" & "comments".

View 7 Replies View Related

Deleting Comments In Blank Cells

May 6, 2009

Is there a way to delete comments in a selected range of blank cells?

View 7 Replies View Related

Adding Comments To Cells Via Macro

Oct 8, 2009

When adding a comment I check for an existing comment, if exist then delete and add new comment and some text in that cell. This works as long as the cell has an existing comment; other wise it advances to the "Else" where I thought I would be entering a comment and text in an empty cell. Why does my macro treat an empty cell as if it has a comment?

View 4 Replies View Related

Insert Comments In Merged Cells?

Apr 20, 2012

The macro below only works for a single cell, how to include merged cells?

Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
On Error Resume Next
Dim cmtText As String

[Code]....

View 2 Replies View Related

Comment Feature Without The Red Triange On Cells With Comments

Jul 22, 2009

I'd like to know how to have the comment feature without the red triange on cells with comments. I didn't want to use data validation comments because I want the hover feature.

View 5 Replies View Related

Edit Comments Not Working For Certain Cells In A Column

Aug 28, 2009

I try to edit comments in cells of a certain column and nothing happens. I am able to edit other comments throughout the spreadsheet, but when I select "edit comments" for these particular cells, no edit box is displayed for editing. It worked fine a couple of weeks ago.

View 11 Replies View Related

How To Give Comments To Multiple Cells At A Time

Feb 4, 2012

columns consist of 1,2

I selected only 1 value of cells

I want to add comments to all the 1 value cells by selecting all 1 by shift + ctl +down

I can put same comments to all the cells?

If you want to have the same comment applied on many cells you could apply it to a single cell, then use the copy and paste special tool bar commands (under Edit) In Paste Special select "Comments" but value is going of that cell.

View 5 Replies View Related

Macro To Convert Range Of Cells To Comments

Jul 12, 2007

Reference the archives at:
http://www.mrexcel.com/archive/VBA/17448.html

How can I modify this sub to skip cells that are empty? I only want cells that are populated within the range to actually display the comment indicator, with the cell text transferred to the comment.

Ideally, I'd also like the text to be moved (not just copied) to the comment and leave an 'X' in the cell, in place of the text that was transferred to the comment, but I'll settle for the action above.

View 9 Replies View Related

Macro To Delete Comments And Unhighlight Cells

Oct 24, 2007

I am having trouble writing a macro to do the following. Someone had created a spreadsheet a while back that highlighted the cell green and inserted a comment with the person's name and date/time if they changed anything in that cell. The macro works great, but I need a macro to undo the changes.

I would like a macro that will remove all comments from the sheet and revert the cells back to their original color. Since the cells encompass many colors, at the very least, I would like the macro to remove the comments and make the cells the default shading (white).

View 9 Replies View Related

Change Cells Comments Commented By Text

Dec 28, 2008

I noticed that I have several (@200) comments that when visible displays Cell X Commented by (my work user number) in the lower left corner of the excel window. I'm not sure how to change this so its the company name instead of my work number. I'd be using a loop to go through each comment but need help with the line that would change this part.

View 8 Replies View Related

Autoupdate Cell Comment Based On Cell Input / Dynamic Cell Comments?

Aug 16, 2013

I'm wondering if it is at all possible to have a cell comment automatically update depending on what data is input in the cell (via user input, VLOOKUP, etc.)?

For example, if cell A1 contains the text "CHARLES" with a comment saying "Employee of the Month", and is then subsequently updated with the new text "JOHN" (again, via direct input, a VLOOKUP, data validation, etc.) is there a way to have the comment automatically update to say something else, such as "Team Lead" for example?

I've considered using VBA to accomplish my goal, but am unsure how to compose an effective code to do so. I've also considered perhaps creating a named table filled with all the different comment possibilities I would like to have used in this cell and then inputting a formula in either cell A1, or the comment contained therein, that would then call the corresponding text from that table based on the data in cell A1. Honestly, I'm not sure that what I'm trying to do is even possible;

View 4 Replies View Related

How To Automatically Update Cell Format In Cells That Reference Another Cell

Feb 22, 2012

Cell C3 has "Joe"

Cell X44 is a VLOOKUP that retrieves "Joe"

Let's say Joe goes on vacation. The workbook user goes in and puts a blue fill in C3. Cell X44 would also need to change automatically.

What's needed to make this happen?

View 1 Replies View Related

Excel 2007 :: Cutting Portion Of Cell Value To Cell Comments

Aug 9, 2012

I have an Excel 2007 workbook with several sheets, and various cells in several of the sheets have column headers with a description in the same cell enclosed in curly brackets, e.g. Header{Description}. I would like to to keep the column headers in their respective cells, but move (cut) the descriptions along with the brackets to the respective cell comments.

View 1 Replies View Related

Printing Cell Comments

Jul 8, 2009

I have several worksheets that have comments in the cells. Most of the comments i have set to "un-hide" and they can be printed. I now have this one spreadsheet where no matter what I do I cannot print the comments.

I must have something turned on or off but for thwe life of me I cannot figure out what it is. I can see the comments on the screen but when I go to print preview they are not there.

View 2 Replies View Related

Cell Comments Don't Appear When Hovering?

Jan 7, 2013

I have several comments being placed into a pivot table from a macro. However, all of a sudden, when I changed the source of the Pivot table, the comments now do not appear when hovering over the cell. They only appear way off to the right if I click "review," "Show/hide comment" or "show all comments."

View 1 Replies View Related

Comments Display On Cell

Apr 30, 2012

I have inserted a comment on a cell.... what required is the comment should show every time the cell is selected/highlighted with the keyboard - no matter the mouse pointer is on the cell or not.

Whereas, the comments only shows when the mouse pointer touches the cell...

View 4 Replies View Related

Automatic Cell Comments

Dec 28, 2006

I have a worksheet with the following in Column E and F respectively:

ID Name
100 aaa
100 bbb
200 ccc
200 ddd
200 eee
300 fff
400 xxx
500 yyy
500 zzz
500 kkk
500 lll
500 mmm

When I input an ID number in Cell A1 and if it is found in the above table, it should bring all the names corresponding to that ID in a cell comment.

The ID Number is repeated in the above table because the names in Colum F are the dependants name for that particular ID.

View 9 Replies View Related

Add Cell Comments Macro

Jan 2, 2007

I am trying to add comments in a selection of cells and where there is a value then the comment should show the formula value of the cell ie if the formula in cell A1 is = 9 + 10 then the comment should show this. This I have got to work, but if I have a comment already the macro fails and I have tried to get round this but I am not clever enough.

Sub InsertingComments()

Dim r As Range

For Each r In Selection
If r.Comment = True Then

View 9 Replies View Related

Udf That Creates Cell Comments

Feb 15, 2007

I have a list on my first worksheet that is sequentially numbered in the first column, and has work activities in the next column. On my second worksheet, I have those sequential activity numbers as the column headers on a new list. Problem is I don't have any room to label the new list by the activity's actual description(second column, first sheet). If I did, I would just use a simple VLOOKUP.

So, what I would like to do is utilize the VLOOKUP to pass the activity description string to a UDF that will create a comment in those column headers. Then when the user mouses over the activity numbers, the respective activity descripiton will pop-up as a comment thus solving my space problem!

View 8 Replies View Related

Sum Numbers In Cell Comments

Dec 5, 2007

I would like to be able to sum quantities held in comments. I am using the Ozgrid VBA module to sum cells based on a fill color, and it works incredibly. However, sometimes I only want to sum a fraction of a cell's contents, and I don't want to use separate fill colors for all possible combinations, so I am thinking to have the comment tab contain the quantity that I want to sum. Example: employee has a total hrs worked of 8 but 2.75 of those hours are to be allocated to sick pay. Typically employees are restricted to taking benefit hours in increments of 4 or 8, and I have some coding to handle that situation.

View 4 Replies View Related

Loop Through Cell Comments

Jan 24, 2008

I need help with my current macro so that it will look in several cells (myrange) if comment(s) are found, write it in a particular cell, so that you end up with all comments written in that cell. If no comment are found then search until the end of the range(or until all comments are found). My current problem is that it is repeatedly writing the comments it finds and I end up with the same number of comments in one cell as number of cells in myrange.

View 9 Replies View Related

Format Cell Based On 2 Cells?

Nov 6, 2013

If F2 is blank and E2 date is older than or equal to today, bold and color E2 RED.

View 2 Replies View Related

VBA To Add Comments Based On Cell Text

Jun 5, 2014

I have a VBA that can add a comment based on the cell value, however, I need it to do it for the whole worksheet and not just one cell. I am pretty new to using VBA's, so this is the best code I could find that would perform what I need. If there is a way to have it do run a vlookup, instead of me listing all the cases, that would be great as well.

VB:
Sub AddComment()
Dim strText As String
With Range("s6")
Select Case UCase(.Value)
Case "UPT": strText = "UnPaid Tardy/Late"

[Code] .....

View 5 Replies View Related

Conditional Formatting If Cell Contains Comments

Oct 3, 2008

Is it possible to use conditional formatting on a cell if it contains comments.

View 2 Replies View Related

Removing Comments If Cell Value Changes To Blank

Apr 29, 2014

I have Main worksheet (sheet 9) and some codes in Sheet 10 which I use as a source for data validation in Sheet 9. So far I have a macro which looks for changes in cells and, when someone chooses a code from the list the macro adds a comment to the cell and populates it with an explanation of the code. The explanations are also in the code worksheet (Sheet 10). It works really nicely but I cannot work out how to remove the comment if the user clears the value in the cell.

My Macro thus far is:

[Code] .....

View 1 Replies View Related

Cell Comments - Not Going Into Edit Mode

Jul 9, 2007

I am using a lot of double click routines in my sheet. In order for the sheet to be more user friendly I have used the comments of cells to tell the user what to do. For instance "Double click to choose type" or some such. Everything works great except that after the user selects what they want from the userform and it hides and the focus comes back to the sheet, the comment is in edit mode. While this is not horrible it is not as nice as I would like. I have tried to have my code send the active cell to another cell and then back, but that doesn't seem to work. Does anyone have any ideas on how to keep the comments from going into edit mode?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved