+ Reply to Thread
Results 1 to 2 of 2

Can text boxes perform like comments-expanding when scrolled over?

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    57

    Can text boxes perform like comments-expanding when scrolled over?

    Using Excel text boxes and shapes, I’ve created a large and complex hierarchy map. In order to make navigating the map quicker, I would like to add a 2nd text box that could be grouped together with the original object that can display a list of prerequisites. I feel that having these displayed at all times would add complexity and make the map harder to navigate, so what I would like to do is have this list hiding until it is scrolled over (like comments in a cell). I’ve attached an example to demonstrate what I’m looking for.

    Any thoughts? Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,008

    Re: Can text boxes perform like comments-expanding when scrolled over?

    Why not use the built-in COMMENT BOX provided for every cell ?

    Right click the cell where you want the COMMENT BOX to appear when the mouse hover occurs. It can be the same cell/s where your label is located.
    Looking at the image below, I've slid the label down, highlighted all the cells underneath the label's original location, merged & centered those cells, then
    right click, INSERT COMMENT.

    You can then edit the comment box by right clicking it. Another window appears with numerous possible edits.

    When you are done, slide the label back over the merged cells.



    Comment Box.jpg

+ 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. Expanding a formula to perform additional functions
    By debbys in forum Excel General
    Replies: 20
    Last Post: 01-25-2017, 03:07 PM
  2. [SOLVED] Comments in frozen panels don't display when scrolled right
    By SaraLynne in forum Excel General
    Replies: 6
    Last Post: 06-27-2014, 02:31 PM
  3. Perform vlookup using prompt boxes
    By The_Cat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2010, 07:52 AM
  4. Replies: 2
    Last Post: 02-19-2010, 03:55 PM
  5. Creating expanding dialog boxes
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2008, 10:52 PM
  6. Comments Boxes
    By bluebadger in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 08:10 AM
  7. Dynamic Comments/Validation/Text Boxes
    By George Andrews in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2005, 06:06 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