Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2015
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Pass Listbox Value to Macro

    I have set up a userform which has a listbox. The listbox is populated from a spreadsheet that has two columns. The first column in the spreadsheet/ listbox has a description and the second column contains a file path. I would like the filepath from the selected item in the text box to be passed as a string to a macro that then uses the value (i.e. a filepath) to set the path for saving an email.

    I have very little VB experience (and amazed I have got as far as I have) and would appreciate any assistance.

    Thanks Alan

  2. #2
    New Lounger
    Join Date
    May 2015
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Solved. It was simples

    Dim path as String
    path = listbox1.value

Posting Permissions

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