Results 1 to 6 of 6

Conflicting events? Clear ListBox for a search and display as you type userform

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2023
    Location
    Pacific
    MS-Off Ver
    2016
    Posts
    2

    Conflicting events? Clear ListBox for a search and display as you type userform

    I need to include a Search and Display function(??), where user types in Textbox name "txtName" and search and displays matching entries in Listbox "lstPipeline". Please see my workbook.

    Search will be confined to Table named "Database" [on "Database" sheet] in the column named "Applicant's Name", but would like to display all columns in the listbox.

    Upon showing the form sub routine Reset () is called which displays all rows of the table. I have tried one or two txtName _Change() subs but always get run time error highlighting clear listbox, hence conflicting events in the title.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search in UserForm and Display in ListBox
    By jaylyn_cpa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-30-2019, 03:43 AM
  2. [SOLVED] Issue with search and display result on ListBox as you type on a TextBox
    By rakotonirinas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2019, 07:15 AM
  3. Using a listbox to display search results in a userform.
    By aayush_1231 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2019, 05:11 AM
  4. Problems with listbox display and search button with the userform
    By SpArKy999 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2017, 04:21 AM
  5. Search Multiple Worksheets using a Userform and display in listbox.
    By nathandavies in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 11-18-2014, 10:22 AM
  6. [SOLVED] Userform Search and Display rows in ListBox
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 10:15 PM
  7. UserForm ListBox Events
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2005, 10:05 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