hi
I wanna fixing code to add hyperlink selected file path in textbox on userform to open the file when press
I wanna fixing code to add hyperlink selected file path in textbox on userform to open the file when press
VBA Code:
Private Sub CommandButton1_Click()
Dim SelFileName As String
SelFileName = Application.GetOpenFilename(Title:="Please select a file")
If SelFileName <> "False" Then
TextBox1.Value = Left$(SelFileName, InStrRev(SelFileName, "\"))
Hyperlinks.Add Anchor:=TextBox1.Value
End If
End Sub