I would use a formula in an adjacent cell:

=hyperlink("File:////" & a1 & ".dwg","Click Me")

if I were entering A100 in cell A1.

Anton wrote:

I can't seem to find the answer to this question. Could somebody help me with
this? I am using a macro in excel for data entry and I want one of the
entries to be hyperlink once it is added. and the address of the hyperlink is
DWG file of that entry. So let say I enter A100, I want it to be hyperlink to
A100.dwg.

Thank you

--

Dave Peterson