+ Reply to Thread
Results 1 to 6 of 6

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

  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

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

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

    Why do you have Activate/Active in the midst of that code?
    If posting code please use code tags, see here.

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

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

    Thanks for your reply
    But not add link in Worksheet Cell ref. to open the Worksheet name as ws.Cells(1, 1)
    When I click on cell
    Error is cannot open the specified file.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

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

    What do you have in TextBox0?

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

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

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

    This is my code of userform

    Please Login or Register  to view this content.
    Last edited by sanjaypalsjp; 04-07-2015 at 04:19 AM.

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

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

    Quote Originally Posted by Norie View Post
    What do you have in TextBox0?

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    Attach my woorkbook for you help

    My Book1.xlsm
    Last edited by sanjaypalsjp; 04-07-2015 at 04:23 AM.

+ Reply to Thread

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