Hi all,

I would like your help in creating a hyperlink in a sheet, pointing from the selected cell to a different cell in the same sheet.

The user is supposed to select a cell, and activate the macro.
The macro should pop up an inputbox to allow the user to select (point) a different cell in the sheet.
The macro should then create a hyperlink to this cell.

The cell will usually contain a Dollar value, and the target cell will usually contain a name of a part.

If possible, I would also like the macro to show, in the cell adjacent to the cell that contains the link, the value of the target cell. For example, the user will see in the linked cell a certain Dollar value (i.e. $1000) and next to it, he will see the value of the linked/target cell (i.e. the part's name).

I have tried and tried but never succeeded in doing that… even when I managed to create a link, it didn't work (I received an error message stating that there is an invalid reference).

Your help will be highly appreciated.

Regards,

Dror