+ Reply to Thread
Results 1 to 6 of 6

Create Hypelink with VBA

  1. #1
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Create Hypelink with VBA

    Hi all,

    It Is possible to generate hyperlinks using vba?

    I attached a file for Example.

    Thanks for the comments

    Greeting,

    Danielle
    Attached Files Attached Files

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

    Re: Create Hypelink with VBA

    Danielle

    What hyperlinks do you want?

    Is it a hyperlink to each cell in column A that begins 'Hyperlink'?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293

    Re: Create Hypelink with VBA

    Yes:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Create Hypelink with VBA

    Indeed, the descriptions in column D should get a hyperlink to the description in column A

    How can I realize that with VBA?

    Greetings,

    Danielle
    Last edited by Danielle22; 08-01-2013 at 09:06 AM.

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

    Re: Create Hypelink with VBA

    This works for your sample workbook but it'll need to be altered fo what you actually have.

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Create Hypelink with VBA

    Thanks, I'm going to try to put your VBA in my file process

    Greetings,

    Danielle

+ 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. Vba cmd1 create workbook cmd2 create worksheet depend upon combobox values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2013, 03:20 AM
  2. Replies: 3
    Last Post: 11-12-2012, 10:33 AM
  3. Excel 2007 : Hypelink Hell
    By JohnFex in forum Excel General
    Replies: 1
    Last Post: 01-26-2012, 09:08 PM
  4. Hypelink and VLOOKUP ? joint use
    By ualtaf in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-29-2010, 10:01 AM
  5. needed: formula for hypelink type Links
    By zerosleep in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2005, 11:22 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