+ Reply to Thread
Results 1 to 1 of 1

Adjusting textbox to filter listbox for 1D array

  1. #1
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Question Adjusting textbox to filter listbox for 1D array

    The code works fine for 2-D array. I am trying to adjust it so that I can filter my 1 column listbox. How would I adjust the parameters for the array, in this case?

    Confusingly, whether I give startow =2, 3, 4, it gives the correct row count for main data in the worksheet as well as listbox.

    This is assuming we have one column range.

    Please Login or Register  to view this content.
    Last edited by immigrated4urjob; 03-31-2022 at 03:06 PM.

+ 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. How to use 2 Textbox to filter Listbox
    By Isabel111 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2022, 02:13 PM
  2. [SOLVED] Filter Listbox or Search Listbox using Textbox
    By crowmagnus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2020, 08:34 AM
  3. Filter by 2 combobox in listbox according to textbox
    By alexis2020 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2020, 11:32 PM
  4. Auto filter listbox when typing in textbox
    By KOBBY123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-22-2018, 03:52 AM
  5. Filter listbox by value in textbox on userform
    By rgwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2018, 03:45 PM
  6. Filter listbox with rowsource using Textbox
    By m0nk3yzaii in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2018, 08:38 PM
  7. textbox search for listbox with an array
    By Wornout8 in forum Excel General
    Replies: 3
    Last Post: 10-09-2017, 05:16 PM

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