+ Reply to Thread
Results 1 to 4 of 4

How do I create a search UI application?

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    USA
    MS-Off Ver
    2007
    Posts
    3

    How do I create a search UI application?

    I'm looking to create a UI for excel 2007 that allows the user to select drop down lists to narrow down a result. For example, I have address, city, and state. I want the user to be able to select a state from the drop down, then select the city from a list of cities in that state, then find the specific address or list of addresses based on my excel data.

    I hope I explained this well enough. FYI I have little to know experience with VBA but I was messing around with the user form function so see what I could create, but this looks to be just for data entry, not data lookup/retrieval.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How do I create a search UI application?

    Hi and welcome to the forum

    Sounds like you need dependant data validation (drop-downs)

    See if the attached sample will get you heading in the right direction, it uses names ranges (1 for each of the lists) and INDIRECT() to pick up which list to use

    If you struggle with this, upload a sample WB and I will take a look for you
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-26-2014
    Location
    USA
    MS-Off Ver
    2007
    Posts
    3

    Re: How do I create a search UI application?

    Hmm I think this is kind of what I'm looking for. I've included a basic mockup of the UI that I would like. Basically people need to be able to select a few criteria and get an output such as an address or a company name. Capture.PNG

    I have 9 columns and about 250 rows so not that much data but enough to need an easy application for people to get results quick.

  4. #4
    Registered User
    Join Date
    06-26-2014
    Location
    USA
    MS-Off Ver
    2007
    Posts
    3

    Re: How do I create a search UI application?

    This looks to be what I'm trying to do but on a larger scale ( with 9 columns)

+ 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. Replies: 2
    Last Post: 09-13-2013, 11:02 AM
  2. runtime error 445 - Set Search = Application.FileSearch
    By djuricap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 04:56 PM
  3. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  4. Alternative to Application.WorksheetFunction.Search
    By mkvassh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2011, 11:57 AM
  5. search text in another application
    By fun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2006, 09:52 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