Display Comment Box over a Userform

[bdb1974]

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

[royUK]

Controls on a userform have the ControlTipText property which can be used to display messages

[bdb1974]

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.

 If Not fTTL Then
    CreateToolTipLabel CheckBox1, "My first line of text." & vbCrLf & "Mysecond line of text." & vbCrLf & "My third line of text.  And I can add more if preferred."
  End If

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

[royUK]

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

[bdb1974]

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

'delete the tooltip window after 3 secs 
 Application.OnTime Now() + TimeValue("00:00:05"), "MyLabel1"

Thanks for you suggestion.

BDB