Results 1 to 2 of 2

Creating a form to filter data?

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    21

    Post Creating a form to filter data?

    Hi,

    I'm trying to create a form which allow me to type some data in and filter it down, however I've never really worked with forms before, so I'm not sure how to link it with the data. Here is a screenshot mockup of what I'd like to do:

    http:// i.imgur.com/ONouM7X.jpg

    The 3 "style code" boxes are the season/STY_NUM/STY_QUAL fields, and the colour and fit are, well, the colour and fit fields.

    It doesn't need to be all fields filled in to bring up the results, i.e. if I just type in "AAA" to the first box and leave the rest blank, I'd still like it to only filter down to any rows with AAA in the season box, and likewise if I fill in all of the fields with specific data, then filter down to that specific combination.
    Also I don't know if it matters or not, but the spreadsheet is refreshable and the amount of rows will change, so it would need to work with the entire spreadsheet really.

    I've managed to get the button to call the form correctly and the cancel button works, which isn't much, but connecting the input boxes with the corresponding columns I don't have a clue how to proceed
    Last edited by Smeghead; 05-16-2016 at 04:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter Data using a user form
    By adelkam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2015, 02:17 PM
  2. Creating a data entry form
    By Bigmal70 in forum Excel General
    Replies: 0
    Last Post: 02-19-2014, 09:29 AM
  3. Need help creating form that populates with data in row
    By benji912 in forum Excel General
    Replies: 12
    Last Post: 03-10-2013, 10:36 PM
  4. [SOLVED] Creating own data entry form
    By Jennster in forum Excel General
    Replies: 5
    Last Post: 08-03-2012, 10:24 AM
  5. Creating a form to request a row of data
    By pktboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-02-2008, 09:02 AM
  6. Creating a form to enter data
    By DanielWalters6 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-20-2006, 01: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