Add Cell Comment With Text

May 28, 2007

if choose a cell then the code works fine, but when i choose a selection of cells
(ex. A1 A2A3 A4) then the code fail to excute in this line: Invalid proceduer call or argument error

.AddComment "hmk :" & Chr(10) & " value was " & ActiveCell.Value

and then fail to excute in this line: typr mismatch error

Selection.Value = (Selection.Value) * r

now here, does have to be loop to solve

here is the full code

Sub test()
Dim r As Integer
ActiveCell.ClearComments

View 5 Replies


ADVERTISEMENT

Show Cell Value (text) In Comment Box Text Or Mouse Tool Tip On Gif Icon

Nov 16, 2007

I have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.

View 14 Replies View Related

Show Cell Value(text) In Comment Box Text, Or Mouse Tool Tip On An Gif Icon

Nov 16, 2007

I have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.

I've look the properties of this to objects and can figure it out.

View 10 Replies View Related

If Date Found In Cell Above, Put This Text In Comment

Feb 12, 2009

Cell B4 is selected by user and then runs the macro. The macro then looks UP (A3, A2, A1 etc) cell by cell until it finds the first cell that has a valid date in it and if that date is same as the date that the macro is being run pastes "This Text" into the comments section (Not replacing everything in the comments but simply adding to it.)

Column A

2/20/2009
(empty cell)
Dave
Jonathan
Steve

2/21/2009
James
Sally
Tyler
(empty cell)
John
Betty

View 5 Replies View Related

Paste Column Of Cell Text As Comment

Feb 17, 2014

I'm trying to copy and column of text (R4:R300) and paste the text as comments in the previous column (Q4:Q300).

View 3 Replies View Related

Insert Pic Into Comment For Every Cell That Has Text Containing String .jpg Or .png

May 10, 2009

I need a nudge in the right direction with how to amend the below code so that it :
1: cycles though all cells in a workbook, and sees whether the text reference of the cell contains a picture filename (i.e. searches for .png or .jpg in the cell contents)
3: if (1) is correct, it retrieves the picture from "C:/Users/jeff/Documents/Standards/" and pastes it as a cell comment background in the cell to the right (and overwrites any comment backgrounds that might already exist there)

The code below does something a bit different: it looks in a defined range, then adds a comment with a background picture retrieved based on the text in the cell to the left.

I'm sure this is a pretty basic change, but my VBA skills aren't up to it...I've only just started reading though Walkenbach's Power Programming! I'm using Excel 2007

Sub InsertComment()
'www.contextures.comxlcomments03.html
Dim rngList As Range
Dim c As Range
Dim cmt As Comment
Dim strPic As String

On Error Resume Next

Set rngList = Range("A1:A5")
strPic = "C:/Users/jeff/Documents/Standards/"
On Error Resume Next
For Each c In rngList
With c.Offset(0, 1)...................

View 9 Replies View Related

Populate Cell Comment Text In UserForm TextBox?

Jul 4, 2014

I have a table with huge amount of data. I use a UserForm with textboxes to populate the information of the required row.

There's a Comment Box text on a specific cell that I need to populate on one of the textboxes but I am unable to do it.

The code I have that works well, populates the cell content:

[Code].....

Now, on that cell, there's a comment text that I need it populated as well on another textbox but it doesn't work. I tried:

[Code] .....

But this doesn't work.

View 8 Replies View Related

Get Username & Text From User To Use With Date & Time In Cell Comment

Jun 22, 2008

i have the following code to insert comments into cells, however if the user cancels the input box (i.e. doesn't insert any text), a comment is still added with their details and the comment 'FALSE'. Is there anyway to stop comments being added if the user cancels the input?

Sub Insert_Comment()
Dim iReply As Integer

Dim cl As Range
Dim sComment As String
Dim sText As String
Dim UserNameWindows As String

View 4 Replies View Related

Add Cell Data/Text To Cell Comment

Mar 24, 2005

attached excel file .I need the data thats there from B4:E8 to be displayed on cell I9 as a comment .is there any way to do it ?

View 6 Replies View Related

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how to copy the contents of multiple comment boxes and paste in a single comment box.

The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

View 6 Replies View Related

Comment Text Property

Nov 17, 2003

Is there a way to change the font size and style of a comment of a certain cell?
I mean is it possible to have the sizes of comments varies in one worksheet?

View 9 Replies View Related

Combining Text From Comment Boxes

Apr 25, 2013

I am trying to combine the text from the comments boxes of a full row of cells into the comments box of a separate other cell in order to provide an overview of the comments in these cells in one place.

View 2 Replies View Related

Resize The Comment Box To The Size Of The Text I Put In?

Apr 2, 2009

when i use a macro to add a comment to one of my cells, if i put in too much text the box doesn't resize itself and you can only read part of the comment. how to resize the comment box to the size of the text i put in?

View 2 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Macro To Add Comment To All Cells Containing Text Within Sheet

Jul 11, 2013

I am in need of a macro that will copy the text from A1, and paste it to a comment on every cell that contains text within sheet 1.

View 4 Replies View Related

Change Default Text Size On Inserted Comment

Sep 26, 2009

Is it possible to change the default text size on comments I insert throughout my spreadsheets? I have to enlarge 100% of them.

View 2 Replies View Related

Insert Text As Comment On Another Sheet Based On Date

Jan 18, 2013

Is it possible to insert text as a comment on another sheet based on a date?

I have Sheet 1, that has 3 columns, Name, Date, Reason

Sheet 2 is a monthly calendar with the dates in E5:AH5 and the names from D6:D10.

What I am trying to do, is when they enter their name, date and reason on sheet 1, I want the reason to to be inserted on sheet 2 as a comment in the cell that matches the date and the name.

View 1 Replies View Related

Change Colour Of Comment Text With VBA If Its Today Date

May 7, 2013

I have a number of comment (all column D) that have lots of data in each one.

The data will appear like this (each new entry (new entry denoted by a date))

01-May 12:58:05 Liam
02-May 16:18:27 Josh
07-May 11:51:26 Bob
02-May 01:13:34 Terry

What i want to know is, can i change the colour of the text in the comment, if its todays date. So in this case 07-May 11:51:26 Bob goes red (its the 7th here for me).

View 3 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

Add Comment To A Cell

Feb 18, 2008

I have some code that finds the appropriate string for a comment from another sheet. I then want to add the string to the appropriate range selection but am encountering an Object Variable or With Block Variable Not set on this section of

Range("C" & i).Select
ActiveCell.Comment.Delete <== Here Or the Next line
ActiveCell.AddComment (Commenta)
ActiveCell.Comment.Shape.TextFrame.AutoSize = True

Where Commenta is the string value I want to add.

View 3 Replies View Related

Excel 2010 :: Add Comment To Cell Without Changing Cell's Contents?

Mar 13, 2012

How, via VBA, would I add a comment from a userform (text box name: txtReason) into a cell that may already have a comment in it? I would like to keep the comment that is in the cell and then have the program add a "/" and the next comment from txtReason..

(using excel 2010)

View 2 Replies View Related

Paste Copied Contents Of A Cell As A Comment In Another Cell

Sep 7, 2012

I am working on a database and trying to remove duplicates. When there are duplicates, I want to take the contents of one cell and copy them as a comment on the cell above (or below).

I tried to work on a small macro to do so, but the contents of the cell cannot be copied (it comes out as a blank).

The long way is to 'double click' in the cell, Ctrl+A, cut, click the cell above, Ctrl+F2, paste. This way is very long as I have thousands of duplicates.

View 4 Replies View Related

How To Reference A Cell In Another Workbook And Return Cell Value And Comment

Nov 2, 2012

What is the best way to reference a cell in another workbook and return the cell contents and the comment on that cell. I would like the comment to come across as a comment in the new workbook becuase the comment is actually a picture.

Hope this makes sense. I did find a macro through googling but I couldn't get it to work? I don't really want to copy and paste because eventually I have hundreds of sheets & thousands of cells to refer to.?

View 2 Replies View Related

Making 1 Cell Equal Another Cell Including Its Comment?

May 18, 2014

I have a spreadsheet with some cells which return values using INDEX and MATCH to bring back the entire details of a person based on there membership number. However I require the comments to be attached with the returned values. The comments have there image in, rather than just text.

I have found some answers with vba, which do the process, however you had to manually enter the cell, from which the comment was to be copied from, into a pop up box. This involved finding the box myself to then select the box to take the comment from. In doing this I had found and read the comment, which is the is the process I'm trying to bypass.

View 8 Replies View Related

To Copy A Cell Content To A Comment Into Another Worksheet In The Same Cell Ref

Jun 25, 2008

I need to copy a cell content to a Comment into another worksheet in
the same cell ref.

sheet1
A1 = apple
A2 = orange

Sheet2 - target
A1 = comment (apple)
A2 = comment (orange)

View 9 Replies View Related

Add Picture To Cell Comment

May 15, 2008

i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Ideally like what happens with the comments where you hover over the cell and the comment would pop up. or failing that may be a cell linking to the image.

View 8 Replies View Related

Lookup For Cell Comment

Jan 16, 2009

make the contents of the cell comment box dependent on the cell contents? eg if the cell contents = 2 and a seperate table says 2 is "poor" can it automatically populate the comment with "poor" ?

View 5 Replies View Related

Insert A Comment In A Cell

Jun 9, 2009

When I insert a comment in a cell, my corporate version of Excel displays my employee number. How can Code a cell to populate this employee number.

View 3 Replies View Related

Return Value From Cell Comment?

Aug 20, 2014

I'm using a function at the moment to copy the comment text from cells, but would like to Change it a Little. At the Moment I have:

[Code]...

There are 3 Basic Groups that the comments refer to, eg: If a comment is a 1,4,11,14 it's Group A. 2,5,12,15 are Group B, etc...

View 2 Replies View Related

Inserting PDF Into Cell Comment?

Mar 14, 2013

Is there a way to insert a pdf into a cell comment? I found how to insert an object but when I do that it covers the entire spreadsheet. I would like to be able to add pdf's to cell comments.

View 3 Replies View Related







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