Posted to microsoft.public.excel.misc

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

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 ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink Function Screentip	Gary''s Student	Excel Worksheet Functions	0	April 18th 07 07:00 PM
Hyperlink "ScreenTip" with Graphics file?	ebublitz	Excel Discussion (Misc queries)	3	November 13th 06 08:00 PM
why can't you right click then paste inside screentip box?	emailring	Excel Discussion (Misc queries)	3	May 11th 06 08:47 AM
How do I Hide Excel 2002 Hyperlink ScreenTip?	phlippee	Excel Discussion (Misc queries)	0	January 31st 06 05:49 PM
VBA-generated ScreenTip from an autoshape	Osong	Excel Discussion (Misc queries)	0	July 21st 05 03:52 PM

All times are GMT +1. The time now is 01:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us