+ Reply to Thread
Results 1 to 5 of 5

Display Comment Box over a Userform

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Display Comment Box over a Userform

    Hi all,

    I found this bit of code that actually creates an on screen message box when the mouse is over a specific object. I managed to get the code to work for me except for one minor issue. The message window is created over the workbook and not the userform. This function and script is being used for mouse move/ mouse over event within my userform for specific objects (IE: labels and checkboxes) . I would like to be able to control where the message box is created on the screen (like a specific region ove rthe the userform). It's not very helpful if the message box gets created behind
    the userform. Any help with this is greatly appreciated.

    Here's an link to the coding:

    http://en.allexperts.com/q/Excel-105...mandButton.htm


    Again, any help is appreciated.

    Thanks,

    BDB
    Last edited by bdb1974; 09-28-2010 at 05:59 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Display Comment Box over a Userform

    Controls on a userform have the ControlTipText property which can be used to display messages
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Display Comment Box over a Userform

    Thanks Roy for pointing this out.
    Controls on a userform have the ControlTipText property which can be used to display messages
    I heard of the property before but, was not aware of it's function. I tried it and it does work.
    This will put the message box over the userform. However, I cannot use word wrap or line breaks to display muti-message-lines. I don't want a user to have to use the Ctrl+Enter to advance to the second line.

    The link to the code I orignially used allows me to VbCrLf to break lines in multiples which it will auto adjust the box size to show them all.

    Please Login or Register  to view this content.

    So, if I can figure out or someone else knows just how to get the tip box to display over the userform at all times, then I will be thrilled.

    Thanks,

    BDB

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Display Comment Box over a Userform

    I don't think that code is relevant, it's not for a userform.

    I don't think you can add lines to the ControlTip like that

    I would have a label to work like this

  5. #5
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Display Comment Box over a Userform

    I was just hoping I could use some system resources to direct the comment box to alway
    be on top (top window) or something.

    About your suggestion on trying labels, that was my first option that I tried.
    I had used a timer function, but the code seemed to get hung up when I called in to run
    in a series to double or triple the time and my mouse crossed over another label tied
    to another mouse move command.

    I may give it another shot and use not a function code for the timeer but just insert

    'delete the tooltip window after 3 secs
    Please Login or Register  to view this content.
    Thanks for you suggestion.

    BDB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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