+ Reply to Thread
Results 1 to 3 of 3

Search Folder and Show Results in Userform List Box

  1. #1
    Registered User
    Join Date
    11-20-2015
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    8

    Question Search Folder and Show Results in Userform List Box

    I got the portion of this macro from this forum and tried to add a userform with a list box
    Thanks to Leith Ross for his work

    Now the results are shown in the Workbook

    Can someone please help me to modify the code and show the search result in the userform listbox.
    My knowledge in VBA is very limited and appreciate your help.
    Thanks
    Attached Files Attached Files
    Last edited by powerplug; 03-13-2016 at 08:48 PM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Search Folder and Show Results in Userform List Box

    The easiest way (without messing around too much with existing code) is to create tempsheet, write results to that sheet, read usedrange into array and use Listmethod to fill listbox and show Userform.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-20-2015
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    8

    Re: Search Folder and Show Results in Userform List Box

    Thanks for the quick reply.
    I think this is the simplest and easiest way to produce the result in the listbox
    But I have couple of questions
    Is it possible to get the result other way around, I mean without going into the worksheet and directly into the listbox?
    In the worksheet result, it is linked to the application and I could open the file directly from the result. Is it possible with userform list?

    Thanks once again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search range for a list of strings, show userform and replace selected cells.
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 01:04 AM
  2. Userform:Search through all ws / show results in Listbox
    By wali in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-22-2015, 09:56 PM
  3. Userform image browse folder, show preview and save to range
    By Mehmet82 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2013, 12:47 PM
  4. Show Search results in userform and edit
    By cruiser102 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 12-21-2012, 07:57 PM
  5. Show Search results in userform
    By StartingOut in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2012, 07:51 PM
  6. Show Folder Contents in Drop Down List
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2011, 03:20 PM
  7. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1