excel followhyperlink with cells

Posted on 2009-12-23
Last Modified: 2012-06-22

I'm trying to setup a button on my excel sheet which will open IE or any other browser using some parameters as cell values:

As you can see in the code below I would like to have

BE as cell A5 for example (both)
Vat as cell A6

Any ideas,

Sub Knop3_BijKlikken()
    ActiveWorkbook.FollowHyperlink Address:="", _
End Sub

Open in new window

Question by:Mutsop
    LVL 3

    Author Comment

    Well already found the solutions...
    For those interested:
    LVL 3

    Accepted Solution


    Sub Knop3_BijKlikken()
        ActiveWorkbook.FollowHyperlink Address:="" & Range("D6") & "&iso=" & Range("D6") & "&vat=" & Range("B7"), _
    End Sub

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now