Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screentip and Hyperlinks
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screentip and Hyperlinks
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ScreenTip in the Header Row | Excel Discussion (Misc queries) | |||
Screentip | Excel Discussion (Misc queries) | |||
Hyperlink Function Screentip | Excel Worksheet Functions | |||
Screentip above shape | Excel Programming | |||
UDF screentip | Excel Programming |