Worksheet Change Hyperlink

I have a question regarding hyperlinks...now what i wish to do is force a hyperlink in what i thoguht would be esily dne in a worksheet change event...hw wrong was i.

Lets say i type 'test' in A1 and press enter...now because i ave pressed enter A1 is no longer the active cell so the code in the sheet change event inserts the code into A2 but because A is blank the 'Text to display' becomes the hyperlinks address.

I wrote a simple with/ end with thinking it would work but it doesnt because of the issue above (Hope i am making sense here)

I got round it by copying the activecell (which would be the cell underneath) and pasting it back to the original target cell, which because it contains text does what i wantbut i am hoping for a much cleaner solution.....

My target column is '1' and only one i will just need to exit the sub anywhere else on the sheet