+ Reply to Thread
Results 1 to 4 of 4

code to automatically convert cell text to comments

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    houston, tx
    MS-Off Ver
    2013
    Posts
    5

    code to automatically convert cell text to comments

    I would like a code to to covert a range of cells in a column to convert to comments. Also, when i update the text in a cell i would like it to change what is in the comment. I do not want the text to show up in the cell because i do not want it to change the size of the cell. If, however, you are able to develop the code to insert and update the text into a comment and allow the cell text to be visible without changing the size of the cell if there is too much content then that will be fine with me as well.

    thank you

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,532

    Re: code to automatically convert cell text to comments

    Try this.

    Please Login or Register  to view this content.
    Right click on the tab you want this code to run on and choose view code, then paste in the code.
    The ranges are set for A1:A10, change this to suit your needs.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Registered User
    Join Date
    10-02-2017
    Location
    noida
    MS-Off Ver
    2016
    Posts
    102

    Post Re: code to automatically convert cell text to comments

    Quote Originally Posted by skywriter View Post
    try this.

    Please Login or Register  to view this content.
    right click on the tab you want this code to run on and choose view code, then paste in the code.
    The ranges are set for a1:a10, change this to suit your needs.
    how to paste this code in macro option and change the range to (s3:s35) why it is not working ???? Fix it please
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,901

    Re: code to automatically convert cell text to comments

    prakash24,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.


    Don't quote whole posts -- it's just clutter.
    If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

    For normal conversational replies, try using the QUICK REPLY box below.

    You have 36 posts and you post a picture of the VBE and say fix it
    Ben Van Johnson

+ 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. Automatically open a comments box when certain text is entered into a cell
    By dfuller29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2014, 05:46 PM
  2. Macro to automatically convert prt scr image-based text to real text in cell
    By jasonfromchico in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 02:27 PM
  3. Code That will Automatically convert a cell's text to Capital...
    By Mhz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2007, 10:57 AM
  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. Replies: 2
    Last Post: 01-23-2005, 06:06 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