+ Reply to Thread
Results 1 to 1 of 1

Pulling Comments from Existing Cell into Another Cell

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    Lubbock, TX
    MS-Off Ver
    2010 & 2013
    Posts
    5

    Question Pulling Comments from Existing Cell into Another Cell

    I found a few sites with Google on how to pull comments from existing cells and put them as text in another cell, using the following formula =getComment() with this slightly modified VBA:
    Please Login or Register  to view this content.
    I am able to accomplish mostly what is intended, however any formating as in Bold, Italics, paragraphs etc. is lost when it puts the text into the cell with the formula. Is there a way to fix this to pull the comment exactly as it is?
    Last edited by Iomega0318; 05-07-2015 at 03:23 PM. Reason: Spelling Corrections

+ 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 cell text to comments in excel 2010 and vise versa (i.e. from comments to cell)
    By senthile in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2014, 12:16 PM
  2. Append comments to a cell which already has comments
    By seanpears99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 07:34 PM
  3. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  4. UDF code to find specific text in cell comments, then average cell values
    By bruch04 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 06:10 PM
  5. [SOLVED] Cell Comments-Is possible to search for data in comments?
    By dmm129 in forum Excel General
    Replies: 3
    Last Post: 10-28-2005, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1