Hello,

I am using a worksheet_change sub to monitor data entries and put a date in column "K"
No i want to add to that routine that if a cell in column H is input by the user as "yes" the gui to insert a hyperlink into that cell opens.

Please Login or Register  to view this content.
can anyone help me adding "Application.Dialogs(xlDialogInsertHyperlink).Show" to this?

Many thanks