Results 1 to 5 of 5

Thread: How to give particular comments to multiple cells in excel?

  1. #1
    Join Date
    Jan 2012
    Posts
    36

    How to give particular comments to multiple cells in excel?

    Hi guys, I just wanted to discuss about excel means Ms Office excel. Actually I just wanted to give same comments to the multiple cells. I am having two columns column 1 and column 2. I just wanted to add comments all the 1 value cells. So can any give me right answer so that I can solve this technical term?

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: How to give particular comments to multiple cells in excel?

    Yes I can give you the one simple technique so that you can solve this technical term easily. You can see the vba code here. If you want to give comments to multiple cells at a time then follow below steps. I hope this will help you. First of all double click on the that particular cell and write the text in the comments box which you want to put all the cells and then press enter.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: How to give particular comments to multiple cells in excel?

    Here one more solution I can give. I case if you select the first destination of the cell, after that CTRL and click each of other destination cell. After that you can use the paste comment function. This may help you.

  4. #4
    Join Date
    Jun 2011
    Posts
    798

    Re: How to give particular comments to multiple cells in excel?

    Here the easiest way to make this possible. This solution is possible for both 2003 and 2007 office. Just copy the message using (CTRL+C) and then, one more thing I just wanted to say that is, if other cells are contagious, just highlight them and if they are not, just hold down the CTRL key and by using this you can highlight each one, after that just right click on that and then bring up pastes special menu. Click on comments and then OK. I hope this will help you.

  5. #5
    Join Date
    Jun 2011
    Posts
    635

    Re: How to give particular comments to multiple cells in excel?

    If you really want to add the comment to the entire cell here I can say that there is only one with the help of the micro you can add the comment to the multiple cell. The given following example will give you instruction how to do this ?
    Sub InsertCommentsSelection()
    Dim sCmt As String
    Dim rCell As Range

    sCmt = InputBox( _
    Prompt:="Enter Comment to Add" & vbCrLf & _
    "Comment will be added to all cells in Selection", _
    Title:="Comment to Add")
    If sCmt = "" Then
    MsgBox "No comment added"
    Else
    For Each rCell In Selection
    With rCell
    .ClearComments
    .AddComment
    .Comment.Text Text:=sCmt
    End With
    Next
    End If
    Set rCell = Nothing
    End Sub

Similar Threads

  1. Replies: 3
    Last Post: 25-01-2012, 12:12 PM
  2. One Click selecting Multiple Cells in Excel 2007
    By Gridharan in forum Windows Software
    Replies: 3
    Last Post: 04-01-2012, 07:40 PM
  3. Sending to Multiple Email Addresses From Cells
    By Aspen in forum Software Development
    Replies: 4
    Last Post: 04-03-2010, 07:16 PM
  4. Delete all Even cells in Excel
    By CAILYN in forum Windows Software
    Replies: 4
    Last Post: 24-06-2009, 11:26 PM
  5. Can't insert cells in Excel
    By Xavier1234 in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 07:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,670,163.67822 seconds with 17 queries