Having trouble with HyperLinkAddress property.

Am looking through this NG for working example
VBA code to pretty much do what the HyperlinkProperty
setting should do. Anybody that can show me how to
roll my own, feel free to step in.

Thx.