Hey friends, is it possible:
Add Hyperlink with userform textbook for Thisworkbook.Worksheet
How can I add
'Add hyperlink in
wsd.Cells(iRow, 1).Hyperlinks.Add = Sheets(Me.TextBox0).Activate
'Add hyperlink
Sheet3.Hyperlinks.Add _
Anchor:=wsd.Cells(iRow, 1), _
Address:=ws.Cells(1, 1).Active, _
TextToDisplay:=Me.TextBox0.Value
'Add hyperlink
Sheet3.Hyperlinks.Add _
Anchor:=wsd.Cells(iRow, 1), _
Address:=Worksheets(Me.TextBox0).Active, _
TextToDisplay:=Me.TextBox0.Value
Above all not work
2nd is Run-time error '438':
3rd is Run-time error '9':
Any idea will be appreciated.
If you have the time, I really appreciate the help.
Bookmarks