Results 1 to 5 of 5
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185

    Excel Hyperlink

    Hi all, is there a method to select all Cells in Excel (3 ,10) to be a hyperlink ? for the full column ?

    ie:

    Dim myLink as Hyperlink
    myLink = "C:\MyDriver\MyFolder"

    .Worksheets(9).Cells(1) = "PRESS AND HOLD 'CTRL'"
    .Worksheets(9).Cells(2, 1) = "AND PRESS 'F' KEY"
    .Worksheets(9).Cells(3, 1) = "WHEN THE SEARCH BOX APPEARS"
    .Worksheets(9).Cells(4, 1) = "TYPE YOUR SEARCH"


    .Worksheets(9).Cells(1, 3) = "SL-NUMBER"
    .Worksheets(9).Cells(1, 4) = "DEALER"
    .Worksheets(9).Cells(1, 5) = "PO-NUMBER"
    .Worksheets(9).Cells(1, 6) = "LIFT TYPE"
    .Worksheets(9).Cells(1, 7) = "LIFT DETAILS"
    .Worksheets(9).Cells(1, 8) = "STATUS"
    .Worksheets(9).Cells(1, 9) = "DELIVERY DATE"
    .Worksheets(9).Cells(3, 10) = myLink
    .Worksheets(9).Cells(3, 3).CopyFromRecordset rs
    .Worksheets(9).Range("C3:K3").Borders(xlEdgeTop).L ineStyle = xlContinuous
    .Worksheets(9).Cells.EntireColumn.AutoFit
    .Worksheets(9).Cells.EntireColumn.HorizontalAlignm ent = xlLeft
    .Worksheets(9).Columns("I:I").NumberFormat = "dd-mmm-yy"Kind Regards

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    each cell is a different hyper?
    or
    the entire col, every cell has the same hyper?

  3. #3
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    Hi, the entire column from cell (3,10) is hyper to the same folder ?

  4. #4
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    Hi all, is there a method to select all Cells in Excel (3 ,10) to be a hyperlink ? for the full column ?

    ie:

    Dim myLink as Hyperlink
    myLink = "C:\MyDriver\MyFolder"

    .Worksheets(9).Cells(1) = "PRESS AND HOLD 'CTRL'"
    .Worksheets(9).Cells(2, 1) = "AND PRESS 'F' KEY"
    .Worksheets(9).Cells(3, 1) = "WHEN THE SEARCH BOX APPEARS"
    .Worksheets(9).Cells(4, 1) = "TYPE YOUR SEARCH"
    .Worksheets(9).Cells(1, 3) = "SL-NUMBER"
    .Worksheets(9).Cells(1, 4) = "DEALER"
    .Worksheets(9).Cells(1, 5) = "PO-NUMBER"
    .Worksheets(9).Cells(1, 6) = "LIFT TYPE"
    .Worksheets(9).Cells(1, 7) = "LIFT DETAILS"
    .Worksheets(9).Cells(1, 8) = "STATUS"
    .Worksheets(9).Cells(1, 9) = "DELIVERY DATE"
    .Worksheets(9).Columns("J:J) = myLink
    .Worksheets(9).Cells(3, 3).CopyFromRecordset rs
    .Worksheets(9).Range("C3:K3").Borders(xlEdgeTop).L ineStyle = xlContinuous
    .Worksheets(9).Cells.EntireColumn.AutoFit
    .Worksheets(9).Cells.EntireColumn.HorizontalAlignm ent = xlLeft
    .Worksheets(9).Columns("I:I").NumberFormat = "dd-mmm-yy"Also can I add text into a cell called SEARCH then click on it to search entire workbook ?
    Kind Regards

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Bing: Excel VBA hyperlink

    Here is one https://www.encodedna.com/excel/how-...-vba-macro.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Email address hyperlink in exported excel file
    By krag in forum Import/Export Data
    Replies: 4
    Last Post: 05-10-2018, 03:12 AM
  2. Replies: 1
    Last Post: 06-03-2016, 03:58 AM
  3. Hyperlink to a specific Excel Worksheet
    By perikillo in forum Access
    Replies: 3
    Last Post: 11-06-2014, 05:07 PM
  4. Replies: 4
    Last Post: 01-05-2013, 11:07 AM
  5. Export to excel with hyperlink converting
    By Jamy in forum Import/Export Data
    Replies: 0
    Last Post: 03-22-2010, 08:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums