+ Reply to Thread
Results 1 to 3 of 3

Help: Need a Search Function that will work with Table (ListObject)

  1. #1
    Forum Contributor onmyway's Avatar
    Join Date
    09-03-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    386

    Help: Need a Search Function that will work with Table (ListObject)

    Hi guys,

    I hope you will be able to assist me. I am looking for a decent, working search function that will work with a Table (ListObject)?

    My current filter/search function does not work with the ListObject, but works fine when the data is in a normal sheet.

    This is the needed functionality (as per current search function):
    1. Search my DB (Column1)
    2. Find the matching record
    3. Double click matching record
    4. Update my UserForm with matching record
    5. Make changes to the record via the UserForm
    6. Save changes

    I have attached a sample of my current search function.

    Please note: some of the code that makes this search function works, is in Module 2 as well!

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help: Need a Search Function that will work with Table (ListObject)

    Aren't you overcomplicating this?

    Why not just filter on column A for the value you're looking for and then enter the new text value in column B on the appropriate row.

    The filter could be automated with a macro and feed off a cell that contains the value you want to find.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor onmyway's Avatar
    Join Date
    09-03-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    386

    Re: Help: Need a Search Function that will work with Table (ListObject)

    Hi Richard,

    That sounds good - i unfortunately don't know how to do that.

    Could you perhaps give me an example? i would really appreciate it.

+ 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. Help: Need a Search Function that will work with Table (ListObject)
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2015, 08:40 AM
  2. [SOLVED] Get Cursor Location in a ListObject table
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2014, 05:24 PM
  3. [SOLVED] Converting Query Table to ListObject
    By x10sion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2013, 06:56 AM
  4. Remove Filter From ListObject Table
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2011, 04:47 AM
  5. Table ListObject Filter
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2011, 07:40 AM

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