+ Reply to Thread
Results 1 to 3 of 3

List hyperlinks on vba userform to open in Internet browser

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    Scotland
    MS-Off Ver
    2013
    Posts
    11

    Talking List hyperlinks on vba userform to open in Internet browser

    Hello,

    I'm trying to create a vba userform which has several website links written in separate labels. When you click the link it will open the hyperlinks in separate Web browser windows or tabs...

    I've looked at different ways of doing this but no joy yet.

    Does anyone know of a very simple way of doing this as I'm new to vba so not quite ready to write complex code.

    Thanks very much.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: List hyperlinks on vba userform to open in Internet browser

    Good morning Jakeyboy

    You can't put hyperlinks on a userform. You've never been able to. That's the bad news.

    The good news is you can fake it. They're not hyperlinks, but they look like hyperlinks and they act like hyperlinks. But they're not hyperlinks.

    John Walkenbach will tell you all about it here, with some code for you to use, and even a downloadable sample.

    HTH

    DominicB

  3. #3
    Registered User
    Join Date
    12-03-2014
    Location
    Scotland
    MS-Off Ver
    2013
    Posts
    11

    Re: List hyperlinks on vba userform to open in Internet browser

    Quote Originally Posted by dominicb View Post
    Good morning Jakeyboy

    You can't put hyperlinks on a userform. You've never been able to. That's the bad news.

    The good news is you can fake it. They're not hyperlinks, but they look like hyperlinks and they act like hyperlinks. But they're not hyperlinks.

    John Walkenbach will tell you all about it here, with some code for you to use, and even a downloadable sample.

    HTH

    DominicB

    Hi DominicB

    Thank you very much for your response, I checked out the link you posted and was then able to get my hyperlinks working. Much appreciated - Cheers mate!

+ 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. Open Pivot hyperlinks in an embeded browser
    By colgabusa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2014, 05:43 PM
  2. Some hyperlinks don't open in default browser
    By biznez1 in forum Excel General
    Replies: 0
    Last Post: 05-17-2013, 02:14 PM
  3. Open Multiple Hyperlinks in Default Browser
    By thelukeeffect in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2011, 02:20 PM
  4. Replies: 1
    Last Post: 02-23-2010, 05:36 PM
  5. [SOLVED] Open Hyperlinks at the same browser
    By p_uriel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-25-2005, 07:00 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