ControlTipText

[Kent Petty]

Hi all,

Is there a way to make ControlTipText to display on more than one line? I'd like to be able to provide more information than will display on a single line across the screen. I tried to set it in an initialize as follows, but it didn't work. It displayed empty boxes instead of inserting carriage returns and linefeeds:

Private Sub UserForm_Initialize()
ControlTipText = "This is a test" & vbCrLf & "of multiple lines" & vbCrLf _
& "within a ControlTipText"
End Sub

Any ideas?

Thanks,

Kent in Alaska

 

[Norie]

Which control do you actually want the ControlTipText to appear over?

I'm not sure the code you posted will work for what you want.

 

[Kent Petty]

Oops....sorry. I'd either assign it to a label or a textbox. I guess the code should have been something like this:

Private Sub UserForm_Initialize()
Label1.ControlTipText = "This is a test" & vbCrLf & "of multiple lines" & vbCrLf & "within a ControlTipText"
End Sub

Is there a way?

Thanks,

Kent in Alaska