Results 1 to 4 of 4

Search Database Excel

Threaded View

khanh19 Search Database Excel 08-14-2013, 06:10 AM
ARGK Re: Search Database Excel 08-14-2013, 07:28 AM
khanh19 Re: Search Database Excel 08-14-2013, 08:25 AM
ARGK Re: Search Database Excel 08-14-2013, 08:54 AM
  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    NL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Search Database Excel

    Hi there,
    I'm an amateur excel user, and not familiar with the VBA and macros. Currently, I have a task from work that I need to create a userform with one listbox, when activate, it links to a combobox option, finally a text box to fill in the description to lookup . And of course, the last one would be a command button to command for search data from a database. I have been trying with different VBA codes and still stuck for almost 2 weeks. The problem is that when I select listbox 1 as filter 1, duplicates values appear, then select one of them linked to combox 2 as filter 2 also have duplicates values. I have no idea how to solve this. Please help me to find the easiest way to nail this task.

    You can find the sample I've attached to see what I mean. Simply, I need 3 filters, 1 for supply plant, 1 for shipto and one for product type and a search button to search for the rest of criteria.

    Many thanks
    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. Excel as Search Engine or database
    By Ewold in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2012, 05:10 PM
  2. userform to search excel database
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2010, 07:38 AM
  3. Search in Excel database and sum the contents
    By bbsslp in forum Excel General
    Replies: 1
    Last Post: 03-18-2008, 02:18 PM
  4. Excel database/search query
    By nike2008 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-10-2008, 07:43 PM
  5. Search from a database sheet in excel
    By lyilaly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2006, 09:28 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