Hi there,
I have a form with many data entry fields and there is a button "Lin
To File" which is supposed to open the insert hyperlink pop up box
When I select the file I want, the address of the file is supposed t
appear in a textbox "txtLinkToFile" and clicking the OK button, th
hyperlinked file name without the complete address has to appear in th
cell.
All that I managed to do is open the pop up box. If someone could hel
out, that would be great.
Below is just a part of the code that I am using.
Thanks all.
Code
-------------------
Private Sub UserForm_Initialize()
'...
'...
txtLinkToFile.Value = ""
End Sub
Private Sub cmdSave_Click()
With Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
'...
'...
.Offset(0, 51) = txtLinkProjectList.Value
End With
End Sub
Private Sub cmdLinkToFile_Click()
'Open hyperlink pop up box
Application.Dialogs(xlDialogInsertHyperlink).Show
End Sub
-------------------
Thanks
--
Message posted from
http://www.ExcelForum.com