PDA

View Full Version : Solved: Dynamic hyperlink in a cell



kishlaya
12-26-2008, 11:19 AM
Hi guys, a merry christmas to all out there.
Here is my problem:

I have a userform with browse button which browses for a specific text file.
The text file address is stored in a particular cell in a particular sheet with the help of this browse buton. .
in the next step the the data from the text file is copied ad pasted in the next worksheet.
Now i want that when the browse button populates the cell in the 1st sheet, the cell should become a hyperlink by itself( please keep in mind that each time the text file address will be different). so that for the next steo(copying the text file) the address is automatically taken by the macro and the data is copied by itself.
I am having problem with the hyperlink part of the problem. If i have created confusion here then my aplogies for it.:banghead: :bug:

Kenneth Hobs
12-26-2008, 12:39 PM
More clarification is needed. You can attach an xls which would help us see the problem and better help you.