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 RepliesI wanted to know how to show a comment when hovering over a checkbox, whether it is enabled or not. I originally added comments in the cell behind each box, but due to many users using different versions of excel and different resolutions of each computer, formatting would be different and it would look awful.
View 3 Replies View RelatedI am looking for a way to have text hover over a cell when the mouse is moved on top of it.
For example
cell 1 - 5 hours
cell 2 - $10,000
I would like to be able to hover over either cell and text appear saying (using formula)
"Cost Per Hour $2,000"
Is this something people have had been able to achieve successfully?
I have seen some VB script for doing this on charts - but not on cells.
There will be thousand of entries which is why I am not looking to use a cell comments box.
I have a cell with a number in it. The number refers to a cost center and is validated by using a drop down menu. In another sheet I have a table that gives a text description of the cost center. Is there a way this description can be shown when I hover the mouse over a cell with a cost center number?
(I can of course use vlookup and display it in the next column, but I am wondering if there is a way to show it only while hovering.)
If there is more data in a cell than can be displayed due to the size of the cell, is there a way to get a real-time preview of all the contents in the cell just by hovering over or clicking on the cell?
View 2 Replies View RelatedFirstly, I am using Excel 2007.
The purpose of my sheet is a timetable.
What I have is a sheet from B2 to N32. What I would like to do is to be able to hover over a cell to show a date.
I have columns that represent the months, column B is January, coulmn C is February, column D is March, etc, etc. Right up to December in column M.
Row 2 represents the 1st of the month, row 3 is the 2nd, etc, etc, down to the 31st of a month.
What I would like to do is when I hover over, for example, cell B2, I would like a box to pop up to say something like, ' What would like to do on the 1st of January??', then maybe hover over H7 and then a box appears saying, ' What would like to do on the 6th of July?
I would like this to happen on all cells on the sheet.
As part of a working spreadsheet there is a section which records faults by way of a numerical list in a dropdown menu. When a number is chosen the fault description appears in the adjacent cell. Is it possible when the mouse hovers over a number in the list the first 20 characters of the fault description could be shown before the fault number is chosen? The attached file is a simple example of the fault numbers and descriptions, in reality some of the faults have longer descriptions with more technical detail.
View 5 Replies View RelatedWhen unprotected my spreadsheet is working fine (apart from the fact that my users can do anything anywhere!) However, as soon as I protect it I am getting a mouse cursor that looks like its hovering over a clickable button? This is odd as the area that its hovering over contains unlocked cells?
Then when I click one of the unlocked cells I get a message box that tells me that Excel cannot locate a macro? Its as though there is a macro being invoked by a click on the screen almost anywhere? as allowing full access only to certain ranges of cells is a pre-req for my project. my file is double the allowable attachable size so I have not attached it.
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;
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 RelatedI 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.
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...
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.
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
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!
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 RelatedI 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 RelatedI 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] .....
Is it possible to use conditional formatting on a cell if it contains comments.
View 2 Replies View RelatedI 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] .....
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 RelatedI have a spreadsheet with several comments with pictures on cells. I want them to show up when you select the cell, instead of having to put your mouse cursor on it. I found this code, but then it shows the comment on the middle of the spreadsheet. I want the comments to show next to the selected cell.
View 4 Replies View RelatedI am dealing with large amount of data.
In the first worksheet, there are multiple comments and I need the property of the cell including the comment to be transferred to the second sheet using a formula.
Suppose in "Sheet1" in cell A5 it says "Number of Sales" with a comment "Check everyday".
Know I need to transfer this to say in "Sheet2" in cell A5. So in A5 of Sheet2 I can type
='Sheet1'!A5
This only brings the text and in this example it would say "Number of Sales" without the comment. All i need is for the comment to be joined with the cell.
I do not how to use Visual Basic and need your help
I cannot use Copy Paste in this case because the file is too large.
If there is no comment it should just write the value of the cell and if no value in cell than it should leave it blank. I will attach a file as a example
I am creating an excel sheet where there is a comments section where the column width is 58 characters. Is it possible for someone putting in comments to have it automatically go to the next row once they enter 55 characters in the row above? I don't want to use wrap text and need to maintain the rows in this section.
View 8 Replies View RelatedI have a worksheet that has user fillable cells from B11-AR53. I want the user to be able to attach comments to cells and then to be able to print them on secondary sheet. I know that excel already can perform this function, but it references the cell address and I don't like that method. I want to have the comments on the printout indexed and tied to an index number in the cell. Creating another worksheet with the comments only is perfectly fine. I am currently using this formula (below) to index the comments on the worksheet that they are attached to.
Ideally my report/second worksheet would list-
1 - Comment that is indexed as 1 would be here
2 - Comment that is indexed as 2 would be here
....and so forth
Sub CoverCommentIndicator()
Dim ws As Worksheet
Dim cmt As Comment
Dim lCmt As Long
Dim rngCmt As Range
Dim shpCmt As Shape
[Code] .......
I would like help with a formula or VBA that would show comments based on cell values.
For example, if cell A1 has cell value '2143', I want comments to be 'Twinkle Twinkle Little Stars' and if cell D1 has cell value '4567', I want 'Humpty Dumpty Fall on a Wall', and etc. How can I do it? I have about 35 different cell value categories. I appreciate any help you can give me. Thanks in advance for your time and effort.
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 .................
What I need to do is write a Vba code that will copy the comments (I believe thats the right term, the ones that make a mouseover box and put a red triangle in the corner of the cell) of a cell and paste them into that cell.
View 9 Replies View RelatedI need to have users be able to modify notes to various pre-set comments on a protected sheet, however I do not want to have them be able to move the comment box (shape)...
View 8 Replies View RelatedI 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 ?