Results 1 to 4 of 4

Thread: Tooltip for Listbox selection - different per selection

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Tooltip for Listbox selection - different per selection

    I want to be able to display a tooltip when you select a value in a ListBox - in other words as you change the ListIndex the tooltip changes - right now I have a label that shows what each function does when you select a value in the ListBox. But the label takes up a lot of space on my userform.
    Any suggestions would be apreciated.
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    You mean the label is one long text across the userform, and you are not able to have multi-lines?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    UserForm controls have a ToolTip property, but its name is not ToolTip, rather, it is name ControlTipText. However, it does not look like it will function the way you want. It appears that ToolTips display when you hover over an object... once you click the object, the ToolTip disappears and stays disappeared until you move the cursor off of the control and then move it back over the control and hover there... selecting an item in your ListBox won't let the ToolTip display until you move the cursor away from the contol and then move it back over it again. Perhaps you can make your UserForm a little taller (say two text lines taller) and put your label down at the bottom of the UserForm so it acts like a Status Bar (which you could update in the ListBox's Click event). Or are you wanting to display a lot more text than that?

  4. #4
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Lets say my list box has 3 different functions you can chose - so when you hover over function #1 (listindex 0) - I then want one tooltip - if youhover over the second - I want the tooltip text to change. Right now I have a multi line label that I substituted the controltooltip with.
    I see Ricks point - I can change the controltooltip via code - as I hover over an item - however I have to let the focus go - then come back to get another choice. So that will not work in reality
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. Replies: 1
    Last Post: 05-03-2013, 04:41 PM
  2. Replies: 2
    Last Post: 04-10-2013, 12:40 AM
  3. Replies: 4
    Last Post: 11-20-2012, 05:11 PM
  4. Using Selection.Address
    By Rasm in forum Excel Help
    Replies: 1
    Last Post: 11-28-2011, 05:20 AM
  5. Mail Range or Selection using VBA
    By LalitPandey87 in forum Excel Help
    Replies: 1
    Last Post: 11-03-2011, 09:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •