Hyperlink vba

[donkey_uk]

. Hi

I have a Excel database and a userform to look-up my music. I want to be able to connect a front cover of the cd file to every cd in the daatbase.

I have created an additional column and created hypelinks in front of each track name. these hyperlinks are connected to the cover of that product which is saved on the drive.

I have created a field on the userform to display the respective hyperlink when a CD/ song name is searched by user.

My problem is that the user form displays the hyperlink name, but its dead.
I want users to be able to click on the hyperlink to view the attached cd font cover pic. I have tried using Textbox and labels to display this hyperlink, but no luck.

anyone knows what I should be using to display this active hyperlink on my userform?? and keep it alive??

[Sean Thomas]

Why do you need a hyperlink?
Why don't you have a list of names, and when you click on them it performs a lookup in a data range containing the names & hyperlinks?

Please Login or Register  to view this content.

or if you are using a combobox or listbox you can have another column with filepaths so when you make the selection you use the select/click method to run some code to open that file.

alternatively this might help
http://j-walk.com/ss/excel/tips/tip71.htm

[donkey_uk]

Hi


Thank you for the reply, not really sure what you mean about youur solution, i have got want i need now with the hyper link. thank you.

I do have one more question, i want to attached a link to a photo as well, so when i click on the cd name the front cover displys in the box but not sure what code i would need for this, i have attached the project so any help would be great.

I will take out the pack size coulum and use this for the link to the front covers, please have a look.


Rave set VBA.xls

[donkey_uk]

anyone ????