You can create a formula using =hyperlink() using VBA.

You can insert a hyperlink (insert|hyperlink) using VBA.

You can use a macro that uses:
Thisworkbook.followhyperlink
and run that macro when you want to.

Vlad wrote:

Thanks Dave for your suggestions

Gary - I want to use VBA to calculate a URL based on some conditions.
Is it possible to use the hyperlink function in VBA?

Thanks

--

Dave Peterson