vba hyperlink

Hello all,

Is there a way to have a button to create a hyperlink to the currently selected cell, and not change the text in the cell? The hyperlink would be to the same folder but I would need to select different picture for different text. Any help would be great .

Thanks

This assumes in the cell you have the name of the file to link to (ie - bird.jpg).

Please Login or Register  to view this content.

Also note, you must insert the folder the file is in (text in red).

This work great but I may not know what the file name is. And can it be opened new excel sheet?
Thanks

Originally Posted by Ikaabod

This assumes in the cell you have the name of the file to link to (ie - bird.jpg).

Please Login or Register  to view this content.

Also note, you must insert the folder the file is in (text in red).

How do you want the macro to figure out the filename?
An input box? Reference from a cell? Open the folder of the files and let the user select one? Choose the next file in the folder? etc etc...

Basically, substitute "Activecell.Value" in Line 2 of the previous code with the code you want to use to determine the filename (ie - if the filename is in cell A1 use the following code: Range("A1").Value)

Finally, if you could clarify the following quote please:

And can it be opened new excel sheet?

Open the files and select one. Yes it could open in a new sheet.
Thanks

Originally Posted by Ikaabod

How do you want the macro to figure out the filename?
An input box? Reference from a cell? Open the folder of the files and let the user select one? Choose the next file in the folder? etc etc...

Basically, substitute "Activecell.Value" in Line 2 of the previous code with the code you want to use to determine the filename (ie - if the filename is in cell A1 use the following code: Range("A1").Value)

Finally, if you could clarify the following quote please:

The following code will put the filename chosen by the user into the activecell's hyperlink (keeping the cells value the same). When the hyperlink is clicked the file will be opened by the default program for that file type (ie - .xls, .jpg, .doc)

Please Login or Register  to view this content.

Ikaabod,

Thanks this is exactly what I was looking for it works great. I owe you .

Glad to help. Thanks for the feedback. Best wishes.