Command Button Hyperlink

R

Rpettis31

I have a text box which can store a hyperlink to a file.
How would I go about accessing this through an event procedure?

Thanks
Robert
 
A

Arvin Meyer [MVP]

How about:

Private Sub cmdHyperlink_Click()
Dim strPath As String
If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Me.cmdHyperlink.HyperlinkAddress = strPath
End If
End Sub

It works for me.
 
Top