Results 1 to 6 of 6

How can I add Hyperlink for Thisworkbook.Worksheet with userform textbook

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    How can I add Hyperlink for Thisworkbook.Worksheet with userform textbook

    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.
    Last edited by sanjaypalsjp; 04-07-2015 at 04:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Transfering Userform textbox filepath to worksheet as a hyperlink.
    By SJJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2012, 05:17 PM
  2. How to hyperlink cell value to userform created worksheet?
    By jwichern1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2011, 12:37 PM
  3. How to code a Hyperlink that links to a UserForm created worksheet?
    By jwichern1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:52 PM
  4. Insert picture into userform from hyperlink on worksheet
    By msommerf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2010, 12:21 PM
  5. why can't I call a sub that's in UserForm from ThisWorkBook
    By 2Raw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 03:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1