Hyperlink text in textbox using command button

Hello

I currently have a Userform as a form of data input on an excel spreadsheet. It is made of several textboxs that simply copy the data in the textboxes to the next empty row on the spreadsheet

It is possible for when one of these textboxes has text in it, to hyperlink that text to a predifined sheet. For example textbox1 is filled with "D12,D15,D25" when the command button is pressed on the userform to insert this data into the sheet is it possible to hyperlink this text to say 'Sheet5' so that the text hyperlinked when it is in its cell?

Regards

Hi ANARDIL1986,

The following macros may help you:

Sub HyperlinkToFile()
  'NOTE: A warning message is generated concerning viruses.  To disable the warning message
  'see https://support.microsoft.com/en-us/kb/925757
  Const sPathAndFileName = "c:\Windows\system32\notepad.exe"
  ActiveWorkbook.FollowHyperlink Address:=sPathAndFileName, NewWindow:=False
End Sub

Sub HyperlinkToSheet()
  Const sSheetName = "Sheet2"
  ActiveWorkbook.Sheets(sSheetName).Select
End Sub

Sub HyperlinkToSheetAndCell()
  Const sSheetName = "Sheet2"
  Const sCell = "D15"
  ActiveWorkbook.Sheets(sSheetName).Select
  ActiveWorkbook.Sheets(sSheetName).Range(sCell).Select
End Sub

Lewis