+ Reply to Thread
Results 1 to 7 of 7

Possible to show comments / popus / textboxes on mouseover in textbox?

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Possible to show comments / popus / textboxes on mouseover in textbox?

    Hi guys and girls,

    my apologies for the vague topic title.
    Here's what I'm trying to accomplish:

    I have a list of ratings that I show in a textbox or comment in a cell.
    The list would look something like this:

    1 star - 20 april 2015
    3 star - 20 april 2015
    1 star - 19 april 2015
    4 star - 18 april 2015

    etc.

    Now, all these stars / dates have additional info - for example
    1 star - 20 april 2015 --> "This is really crappy, I don't want to use this anymore!"

    I want the additional info to be shown when the user clicks or goes with the mouse over that rating.
    The additional info can be a few words or an entire paragraph. I don't know that in advance.
    Is that possible?

    I know it's possible when I put the ratings in a cell or multiple cells, but I cannot change cell formatting and not every cell would have the same number of ratings, that's why I want to show the shortlist in a textbox / comment and the details in an additional textbox or comment after that.

    Thanks for any help!

    Jasper

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    *bump*

    Anyone?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    It's not completely clear how your information is currently presented.

    If it's a shape then you could assign a macro to react to a click. But if the shape contains multiple items you will not be able to tell which one was clicked.
    You might be able to use multiple shapes in a group.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    Hi Andy,

    thanks for the reply!
    I was thinking about presenting it in a userform and putting the text in labels which I can then make click-able.
    However, that still means the user has to click the label, since I don't think I a 'on mouseover' event is available for that.
    And comments to labels are not available as far as I know.

    I'll try and go that route if there's no alternative, but I'd really love a 'on mouseover' event triggered on a shape or userform.

    Thanks,

    Jasper

  5. #5
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    I've added a screenshot of what I'd like it to be ideally. So on mouseover of the first rating, have a popup comment style showing the details.

    example.jpg

    Is anything like that possible?
    Please click the * below if this helps

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    If you are using a userform then you can capture mouse events.

    This example uses both controltiptext and mousemove event.

    The comment like label must be within the confines of the userform
    Attached Files Attached Files

  7. #7
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Possible to show comments / popus / textboxes on mouseover in textbox?

    Hi Andy,

    this is fantastic! Thank you - I'll have lots of fun to play around with this
    Much appreciated!

+ 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. Macros needed to show popup when mouseover
    By Atan4 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2013, 11:03 PM
  2. [SOLVED] Several Textboxes values into one textbox
    By sagar007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-17-2012, 08:11 AM
  3. Replies: 2
    Last Post: 05-30-2012, 02:18 AM
  4. [SOLVED] i hate your formatting popus
    By Format Popups in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 09:30 PM
  5. comments mouseover on frozen cells
    By T-ReXTC in forum Excel General
    Replies: 1
    Last Post: 02-09-2006, 06:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1