Screentip
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 |
Screentip
=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 ? |
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 ? |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com