Is it possible for a hyperlink to be active in a form control ?

I have a situation where a user enters a file path and name (the hyperlink)
into a textbox, which is subsequently recorded in a sheet cell for
reference.

If this record is reload, I would like the hyperlink to be active and when
double-clicked activate the link and open the document, which might be
another Excel Workbook, Powerpoint Presentation, Word Document of HTML file

Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

Nigel,

Just have a label on the form, change the label text to match the hyperlink
address, and in the labels click event, uses the hyperlinks collection. When
you initialise the form, change the caption on the lable.

e.g. When the label is clicked on one of my forms, it looks up an address
held in one of its own sheets, and follows it. You can set the font to blue,
underscore to on in the font formatting for the label to make it look like a
normal web address.

Private Sub lblLink_Click()
ThisWorkbook.Sheets("Version").Range("EDHome").Hyp erlinks(1).Follow
NewWindow:=False, AddHistory:=True
End Sub

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Nigel" wrote in message
...
Is it possible for a hyperlink to be active in a form control ?

I have a situation where a user enters a file path and name (the
hyperlink)
into a textbox, which is subsequently recorded in a sheet cell for
reference.

If this record is reload, I would like the hyperlink to be active and when
double-clicked activate the link and open the document, which might be
another Excel Workbook, Powerpoint Presentation, Word Document of HTML
file

Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---