Results 1 to 4 of 4

Duplicating cell comment

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    MS365 V2308
    Posts
    279

    Duplicating cell comment

    Carrying on from a previous post

    https://www.excelforum.com/excel-pro...ml#post5652203

    the working vba is as below

    For Each tcell In Range("T4:T315")
            With Range("$X$316:$X$329")
                Set found = .Find(tcell.Value)
                If Not found Is Nothing Then
                    tcell.AddComment ("Text")
                         End If
            End With
        Next tcell
    What would i need to add or change to the vba for it to add the comment to the corresponding cell in H column?

    Currently the cell value in column T changes to pink and a comment is added

    ie T4 turns pink as matching a criteria and a comment is added. I need the comment to be added to H4
    Last edited by ukphoenix; 03-27-2022 at 04:14 PM. Reason: Resolved code

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Force Comment when Condition Met. Comment appears on the wrong cell.
    By annap0tchi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2020, 04:58 AM
  2. [SOLVED] Function to return comment from a cell, or null string if no comment
    By Monkihunta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2017, 01:01 PM
  3. [SOLVED] Show comment on mouse over cell rather than over comment icon....?
    By BellyGas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2015, 09:05 AM
  4. Check if cell in range is empty, if it is delete comment else format comment to
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2015, 01:15 AM
  5. Cell's text / comment (no comment )
    By Marianus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 06:05 AM
  6. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  7. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1