Results 1 to 9 of 9

UserForm with filtered data

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    UserForm with filtered data

    The attached has a very simple UserForm (a drastically simplified version of something I use at work). By using the spin button you can cycle through the records on the Data sheet.
    This all works great, however, when the data is filtered it falls over when you get to a record that's not showing due to the filter.

    So I'm looking for an elegant solution to get around this. Any ideas?

    Thanks in advance

    B
    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. Filter sheet data with ComboBoxes, then Update UserForm with filtered sheet data
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 05:59 AM
  2. Populate a textbox on Userform with data from a filtered range using VBA
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2014, 04:20 AM
  3. Userform to show filtered data
    By onsid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2013, 02:56 PM
  4. [SOLVED] populate userform with filtered data
    By crossy5575 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2012, 11:47 AM
  5. Load Userform ComboBox with filtered data
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 05:34 PM
  6. Filtered Data in userform
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2007, 03:46 AM
  7. Using Filtered Data in Userform Listbox
    By sfinney in forum Excel General
    Replies: 0
    Last Post: 03-18-2005, 11:09 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