+ Reply to Thread
Results 1 to 2 of 2

If A1 has a comment and A2=A1, how can I make the A1 comment show up in A2?

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    detroit, michigan
    MS-Off Ver
    Excel 2003
    Posts
    60

    If A1 has a comment and A2=A1, how can I make the A1 comment show up in A2?

    Hey all,

    Question essentially in title. I've got two cells, A1 and A2. A1 has a comment and A2 = A1. How can I make the cell A2 have the same comment as A1 since the values are the same?

    Thanks!

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: If A1 has a comment and A2=A1, how can I make the A1 comment show up in A2?

    Hi, levitt,

    AFAIR you would either need to do it by hand or use some code to copy ove the comment.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy contents of multiple comment boxes and paste in a single comment box
    By xxJaRxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2014, 12:39 PM
  2. 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
  3. Make OnEntry comment box show all entered values?
    By moleary in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2011, 01:42 PM
  4. Replies: 0
    Last Post: 09-04-2008, 01:35 PM
  5. [SOLVED] How can I edit a comment w/o first having to select Show Comment
    By Mary Ann in forum Excel General
    Replies: 1
    Last Post: 08-25-2005, 08:05 PM

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