+ Reply to Thread
Results 1 to 13 of 13

Creating a floating text box containing a hyperlink

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Creating a floating text box containing a hyperlink

    Hi all,

    I have a single spreadsheet containing many tabs and the first tab being a contents tab listing every tab within the spreadsheet with a hyperlink next to each for quick reference. That is the easy bit.

    What i am trying to do is create a universal floating text box which when clicked will jump straight back to the contents tab.

    i.e. i can jump from the contents tab to each individual tab using the hyperlinks but i can't jump from the individual tabs to the contents tab. I have to dump export data into the individual tabs so creating hyperlinks within each one to the contents page doesn't work.

    I've never used vba before but i am really keen to start and i think it may help me with what i'm trying to achieve. If i could get a noob's guide on how to get this punched out it will really set me on my way.

    Cheers
    Neill

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Creating a floating text box containing a hyperlink

    It's already builtin in Excel.

    go to the leftdown position in your screen to the sheets' browse buttons .
    Rightclik the mouse; hyperlinks to all sheets you'll find there.



  3. #3
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Creating a floating text box containing a hyperlink

    Quote Originally Posted by snb View Post
    It's already builtin in Excel.

    go to the leftdown position in your screen to the sheets' browse buttons .
    Rightclik the mouse; hyperlinks to all sheets you'll find there.
    wow i learned something new there. Thanks snb!

    It would still be nice to bring in a universal floating textbox to maybe show off a bit and improve my excel cred at work as i just started out. Anybody know if this is possible and won't involve too much code?

    cheers again

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,864

    Re: Creating a floating text box containing a hyperlink

    You will not get a floating textbox.

    Instead consider placing a return hyperlink in the top row and freeze the top row.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Creating a floating text box containing a hyperlink

    Quote Originally Posted by Andy Pope View Post
    You will not get a floating textbox.

    Instead consider placing a return hyperlink in the top row and freeze the top row.
    Just got an email from a mate of mine who first showed me textboxes. He said it's possible but would involve alot of code so that puts a damper on things somewhat.

    I need to clear the data in the tabs every month and paste in the new months data so that would wipe out any hyperlinks. Data also needs to be in the exact format and cells as pasted so no moving or deleting rows/columns. New tabs are added in some months hence the floating textbox idea.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,864

    Re: Creating a floating text box containing a hyperlink

    Only you know the control you have over the data but if you are clear and pasting I would have though you could handle a spare top row.

    Another option for xl2003 is to create a floating toolbar. Depending on your hyperlinks the Web toolbar may just work as is.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Creating a floating text box containing a hyperlink

    See the free addin (Navigation Toolbar here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  8. #8
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Creating a floating text box containing a hyperlink

    To return to the 'home'sheet you can create a button in the menubar.

    Please Login or Register  to view this content.
    That triggers the macro 'hoom' in a macromodule
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Creating a floating text box containing a hyperlink

    thanks for all the replies. Having never used vba before, how would i go about implementing the above code?

  10. #10
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Creating a floating text box containing a hyperlink

    see the attachment.

    start a macro:
    Alt-F8/ select tst44/run
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Creating a floating text box containing a hyperlink

    cheers mate, works a charm.

  12. #12
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Creating a floating text box containing a hyperlink

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

  13. #13
    Registered User
    Join Date
    03-01-2013
    Location
    Washington, DC
    MS-Off Ver
    Excel 2004 Mac
    Posts
    1

    Re: Creating a floating text box containing a hyperlink

    Thanks to all. Solved my issue with ease.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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