Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Hyperlink a cell to run a module

    I have a module that when run triggers my physical phone to call a number through our OAISYS phone system. What I would like to do is have a spreadsheet with names in one column and extensions or phone numbers in another column. Then when I click on the hyperlinked name of that person, it runs the module calling the number in the row corresponding with the hyperlinked name.

    Is it possible to have a cell hyperlinked to run VBA code? I've never done this before.

    Thanks,
    Joshua

  2. #2
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Is there no way to have a hyperlink run a module?

  3. #3
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Yes you can. When you click on a hyperlink it raises the worksheet's FollowHyperlink event, so you can use the Worksheet_FollowHyperlink() event handler to do this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •