+ Reply to Thread
Results 1 to 3 of 3

VBA - Combine text into a comment in a range

  1. 10-26-2021, 12:28 PM #1
    jsneak
    jsneak is offline
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    VBA - Combine text into a comment in a range

    Hi all,

    Wondering if anyone would be able to help me with an issue I've currently got where I need to merge the text in Col C to the text in Col B

    Col A Col B
    1 A
    2 B
    3 C
    4 D
    5 E

    Anything in Col B would become a comment on the value in Col A (The range is bigger than 5 - but as an example)

    Thanks in advance!
    Last edited by jsneak; 10-26-2021 at 12:30 PM.
    Reply With QuoteRegister To Reply
  2. 10-26-2021, 01:06 PM #2
    jsneak
    jsneak is offline
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: VBA - Combine text into a comment in a range

    Apologies, i found the answer to my question

    If anyone is interested, answer below 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-26-2021, 01:07 PM #3
    Joske920
    Joske920 is offline
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: VBA - Combine text into a comment in a range

    hi,

    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show cell value(text) in comment box text with a particular arrangement
    By bkwins in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2015, 02:15 PM
  2. 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
  3. Show cell value(text) in comment box text, or mouse tool tip on an gif icon
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-19-2014, 06:50 AM
  4. Cell's text / comment (no comment )
    By Marianus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 06:05 AM
  5. 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
  6. 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
  7. [SOLVED] Range's comment text
    By Mircea Pleteriu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1