Dan,

Just reference it with the ScreenTip parameter like this:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", ScreenTip:=Worksheets("Sheet3").Range("B5").Value,
TextToDisplay:="Sheet2!A1"

hth,

Doug

"Dan" wrote in message
...
When creating a hyperlink Text to disply is simple enough. but can you
have
the screentip text reference a cell from say sheet3 cell b5?? if so how?