Using vba to hyperlink cells when populated

[carlandtina02]

Hi All,

Is there a way of using VBA to create a hyperlink to a cell only when the cell is populated, for eg. All cells in colum E will have a reference sheet number (12345678) and when selected (clicked on) will look in C:\Documents and Settings\carl.walker\My Documents\Machine DWG for that file named 12345678 and open it?

The cell currently gets populated by a userform (if that makes any odds).
I have uploaded a copy of the workbook to veiw.


Any help or guidance would be much appreciated.

Thanks in advance
Carl