-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
cell comment
-
R
VBA for Cell Comment with User Name, Text Description, Cell Value & Date
Hi, Any help on this would be greatly appreciated, i have already spent so much time on this & nothing is of any help. I need a VBA which i can run on a selected cell & get the cell comment with user name, Text Description with Cell Value & Current date just like below: Tehlan, Romil: Value...- rtehlan
- Thread
- Replies: 8
- Forum: Excel Questions
-
B
Send E-mail & Comment based on Cell Value
Hello, Awhile back one of your users (Chris Mack I believe) was super patient with me and my limited VBA skills and helped me develop some macros for a to add/remove lines to track some paint emissions limits. That portion is working great but I've found a need to add another 'feature' because...- BluOx
- Thread
- Replies: 1
- Forum: Excel Questions
-
A
VBA to copy Cell.Formula to cell comment
Hi everyone, I have had a shot at some code that will check if a cell in the selected range has a formula and if so add this formula as a text string in the same cell's comments. Public Sub CellFormulaToCellComment() Dim CellInRange As Range 'Dim CellComment as String For Each CellInRange...- AusSteelMan
- Thread
- Replies: 2
- Forum: Excel Questions
-
R
Copying Image From Cell Comment
I've got a problem with images in comments and I was hoping for some help. I've been dabbling with creating a macro that allows a user to select an image from "my pictures" and then automatically inserting that image into a cell comment. Unfortunately, while the macro works great, we...- Ranger006
- Thread
- Replies: 1
- Forum: Excel Questions
-
A
Use cell text as a cell comment of another cell
Hi there, I have another question that I hope someone can help me with this time. (It appears that my first question was a real stumper! See http://www.mrexcel.com/forum/showthread.php?t=421823) My spreadsheet has a dynamic range dropbox validation in Sheet 1 Col T. What I would like to...- AusSteelMan
- Thread
- Replies: 6
- Forum: Excel Questions
-
M
HTML markup to add comments to excel cell
HTML markup to add comments to excel cell Hi, I want to create an html string such that if I just paste that html string into an excel sheet it will add a comment to one cell. Something like: <table> <tr> <td ss:Comment="This is my comment text">my cell text</td> <td>another cell</td> </tr>...- MatrixBoy2
- Thread
- Replies: 1
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 35
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 35
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...