Screentip
Thanks!
--
Gary''s Student - gsnu200783
"Gord Dibben" wrote:
=HYPERLINK(Sheet1!D10,"now is the time" & CHAR(10) & "for all good men")
Don't forget to set wrap text and autofit.
Gord Dibben MS Excel MVP
On Sat, 3 May 2008 07:23:00 -0700, Gary''s Student
wrote:
I can insert a hard return in a hyperlink screentip in VBA with:
Sub Macro2()
With Selection.Hyperlinks(1)
.ScreenTip = "Now is the time" & Chr(10) & "for all good men"
End With
End Sub
Can I do this without VBA ?
|