+ Reply to Thread
Results 1 to 7 of 7

Adding descriptions from a table to a text box

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Adding descriptions from a table to a text box

    Hello all,

    I'm currently using the code below to paste shapes into a chart based on date location:

    Please Login or Register  to view this content.
    It works fine, but I'm hoping to include the descriptions from the Data Inputs tab underneath its corresponding shape. I tried testing with the .AddTextbox method to just insert "Test", but to no avail.

    Any help is apprecaited; sample workbook can be referenced as well.
    Attached Files Attached Files
    Last edited by mcmahobt; 11-30-2016 at 03:57 PM.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Adding descriptions from a table to a text box

    As an option you can add Comment to the cell you paste the shape.

  3. #3
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Adding descriptions from a table to a text box

    That is true, but I would rather the comment show under the shape so that a user can identify what the shape corresponds to vs. hovering over with a cursor to see the contents.

  4. #4
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Adding descriptions from a table to a text box

    Ok, but you can turn on "Show All Comments" and there will be no need to place cursor over the cells.
    By the way if this description is a long text - those comments will cover each other (when shapes are situated close)

  5. #5
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Adding descriptions from a table to a text box

    Hoping to have this as dynamic - that is, I wouldn't need to insert the comments manually. Still leaning towards the VBA method.

  6. #6
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Adding descriptions from a table to a text box

    Comments can be added by VBA (red code)
    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Adding descriptions from a table to a text box

    I like the idea, just not the aesthetics of the results. I was hoping to do something similar with text boxes, but the method for adding text boxes doesn't seem as easy as the .addcomment method.

+ 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. Macro to remove characters preceding text descriptions
    By agent.orange in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 06:32 AM
  2. Removing text from item descriptions on mass?
    By Prince Dakkar in forum Excel General
    Replies: 2
    Last Post: 10-28-2013, 12:01 PM
  3. Adding argument descriptions to my xlam UDFs
    By Andrew_Harris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 06:05 AM
  4. Data Consolidation with Text Descriptions
    By vin_e in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2010, 01:40 AM
  5. Adding descriptions to product codes
    By paulboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2009, 05:26 AM
  6. Table with descriptions of ButtonFaces
    By Scriptick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2006, 04:25 AM
  7. Adding cells with similar descriptions
    By Matt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2005, 01: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