Results 1 to 20 of 41

Thread: Sleeper: Load Folder Content in Single Column List Box

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    VBAX Contributor
    Joined
    Dec 2004
    Posts
    122
    Location
    I think i did it


    Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Link = ListBox1.Text 
    On Error GoTo NoCanDo
    ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
    Unload Me
    Exit Sub
    NoCanDo:
    MsgBox "Cannot open " & Link
    End Sub
    Last edited by johnske; 06-25-2005 at 05:11 AM. Reason: edited to include VBA tags

Posting Permissions

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