gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
I have a button on my form that I want to use to first copy the value from the active cell to the clipboard (which I have the code below) and then opens the hyperlink below
How do I add the hyperlink to my code
Thanks
How do I add the hyperlink to my code
Code:
Sub CopyToClipboard()
Dim clipboard As MSForms.DataObject
Set clipboard = New MSForms.DataObject
clipboard.SetText Selection
clipboard.PutInClipboard
End Sub
Thanks