Force a user to carry out a task after entry into a specific cell

Hi,

I have a column with cells relating to job numbers(consecutive); each job number relates to a pdf file which contains full job descriptions and I use the table as a progress summary. When a user puts a new job number into a cell how do I get excel to ask them to hyperlink that cell to the related job? or alternatively the jobs are all named DCK 0001, DCK 0002 ... and are kept in the same folder is there a way to automatically create a hyperlink to the file when the job number is entered?

Regards,
Andy

can you upload an example workbook?

See document attached

Give this a try.

I gave you 2 options to choose from, BeforeDoubleClick & SelectionChange.
The SelectionChange will drive a user crazy I believe, while the DoubleClick option depends on the users.

The one problem I was having with your concept, once the user Hits the Enter or Tab key to active the macro.
The active selection has now changed from what it should be, so the hyper link will not be place in the proper cell.
The one method I found that works is by clicking on the Check Mark next to the Formula Bar.

There are 2 sheets, Sheet1 uses Selection Change and Sheet2 uses Double Click action.
Give these a try, I'll continue to look for a method that uses your concept.
Let me know what you think.

work orders.xlsm

After thinking about it for a little while, I believe this is what your looking for.
Let me know what you think.

work orders rev2.xlsm

Pl see the attached file.
Worksheet_change event is used.
When data is entered in A column It gets Hyperlinked as you wanted.

Thanks for your help gents, I went with the double click option. Unfortunately with direct linking I'm only entering part of the file name in the column (DCK000...) and the second half of the file name is different for each DCK number. So for a direct link like in BuckoAk 3rd option and kvsrinivasamurthy option it is either looking for a full file name or for a DCK number connected to (- Stern Platform Sika.pdf) where this .pdf section could be anything but is always prefixed by a DCK000... number.

Thanks for your help again all; if you fell like continuing to fool around with the coding kvsrinivasamurthy is close but instead of linking to - stern platform skia.pdf it needs to do a search and add a file where part of the file name is a DCK000.. number.

Cheers Fellas
Andy