+ Reply to Thread
Results 1 to 2 of 2

Userform code to show data in listbox if criteria met

  1. #1
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Question Userform code to show data in listbox if criteria met

    Hello,

    I have the following userform code which just populates a listbox with data from a table:

    Please Login or Register  to view this content.
    I am needing to amend the code so that it only adds the data that matches a certain criteria, so I only want the data included that has a certain value in column J.

    How do I do this please?

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: Userform code to show data in listbox if criteria met

    Set an example and the desired result in the book
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

+ 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. [SOLVED] VBA code to show updated data in the listbox after the data is entered and button clicked
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-25-2015, 04:23 AM
  2. [SOLVED] How show in Listbox (userform) specific files
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-31-2015, 10:12 AM
  3. 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
  4. [SOLVED] How to show data in UserForm ListBox from WorkSheet?
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2014, 05:26 PM
  5. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  6. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  7. UserForm;Listbox Select Show Picture
    By samsara in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2009, 09:48 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