Macro to Execute Hyperlink

P

Phil H

Cell F5 is being populated by a ComboBox. If cell F5 has the following text,
I want Excel to execute an associated hyperlink:

Cell F5 Hyperlink address
----------------- -----------------------------------------
Facilities C:\Documents and Settings\....\Facilities.xls
Maintenance C:\Documents and Settings\....\Maintenance.xls
Overhead C:\Documents and Settings\....\Overhead.xls

For example, if the user selects “Facilities†from the ComboBox, the macro
would execute the hyperlink contained in the code, taking the user to the
Excel workbook C:\....Facilities.xls.

What would the code be?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with hyperlink macro 0
Broken Hyperlinks 0
VBA - exporting serial letters to single documents 0
using LEN / LEFT / MID / FIND functions to create a list 5
Broken hyperlinks in excel 2007 0
Macro for checking data in a cell against another cell andcopying/pasting data 8
Extract Text in braquet and list of terms from 2 Docs 3
Weird behaviour when entering hyperlinks 0

Top