+ Reply to Thread
Results 1 to 8 of 8

Live Search and Auto Populate Fields on User Form

  1. #1
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Post Live Search and Auto Populate Fields on User Form

    I've managed to Frankenstein a user form that actually works rather well, what I am missing and can't seem to get working is a search box that will list results in a list box and then when an item is clicked in the list box, the details are populated in the provided area. The search box would only search for the Jack ID (column B), match any part of the ID, so you don't have to type the entire ID to find a match or matches. Your help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Live Search and Auto Populate Fields on User Form

    I recognise that layout from somewhere
    Try the attached, the textbox works by filtering out those items that do not contain the search word.
    For instance if you type "DA03" it will get that part of the string - selecting the item in the listbox fills the textboxes for reference.
    I have annotated those parts of the code that are new.
    Also this process disables the 'remove' & 'update' options, as the filtered listbox loses its relationship to the database.
    To use this type of search for editing purposes involves introducing a method of row tracking.
    torachan.

  3. #3
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Re: Live Search and Auto Populate Fields on User Form

    Thanks for the assistance. How would I go about row tracking so that I can update straight from the form? I made a few changes, so I'm attaching an updated version.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Live Search and Auto Populate Fields on User Form

    Alterations are all contained in the ListBox Sub

  5. #5
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Re: Live Search and Auto Populate Fields on User Form

    That didn't work. That just updates row 1 or overides date already in row 1.

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Live Search and Auto Populate Fields on User Form

    omitted to check properly
    rowcounter now working in update.

  7. #7
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Re: Live Search and Auto Populate Fields on User Form

    Last question, can the listbox retain the font/cell color from the sheet?

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Live Search and Auto Populate Fields on User Form

    I do not believe it to be possible.

+ 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. Live Search MULTIPLE fields SIMULTANEOUSLY [search as you type]
    By deannaed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2018, 02:06 PM
  2. How to stop and confirm auto population fields in user form based on one value
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2018, 05:03 AM
  3. [SOLVED] Auto populate user form field with command botton
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2016, 08:36 AM
  4. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  5. [SOLVED] Auto Populate Form Fields
    By Cardan in forum Word Formatting & General
    Replies: 4
    Last Post: 01-09-2014, 12:54 PM
  6. User form to populate fields of Report/pivot table
    By jasniya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2011, 05:39 AM
  7. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM

Tags for this Thread

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