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 ?
--
Gary''s Student - gsnu2007

=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 ?

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 ?