I have the following situation

I have a worksheet database in which there are 4 columns in which hyperlinks
can be added.

On a userform there are 4 controls that the user can enter a hyperlink as a
text string (path and file), which are subsequently stored in the database
as strings.

1. I do not appear to be able to store them as hyperlinks on the worksheet,
is there a method for doing this. Or can I / do I need to use the standard
hyperlink form in Excel to establish the link correctly ?

2. Having crerated the links, is it possible to activate the links from
within the UserForm, I have tried using the hyperlinks collection (having
manually set some up) but it appears in order to do this I need to maintain
an index of where all the links are. I would much prefer to click the
UserForm control to open the link

I am developing in Excel 2002 but need to make it compatible with Excel 97

TIA
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 =---