Hi Could someone help me on this........

If I have a selected cell in the workbook on the first sheet and want the vb code to automatically create a hyperlink to the last added sheet.this should all happen when you click the ok button on a userform.

Thank you for the help.