Screentip

[Gary''s Student]

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 ?

 

[Gord Dibben]

=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

 

[Gary''s Student]

Thanks!
--
Gary''s Student - gsnu200783

=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