+ Reply to Thread
Results 1 to 5 of 5

creating VB code using advanced search criteria with multiple data validation lists?

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2010
    Posts
    3

    creating VB code using advanced search criteria with multiple data validation lists?

    Hi,

    I've been reading through many forums and looking at many examples but still cannot find what I'm looking for. The closest I came to was one from Contextures - DataValSelectName.

    I'm trying to make a commercial invoice sheet where you can easily select particular brands, then in the second list, select a product from that brand. The problem I have is the list gets updated every week and it contains a thousand products, so I require something similar to how the DataValSelectName.xml works, but with multiple entries. Here is a link to the file in question here .

    I've included what I'm currently working on with comments to best help people work through what I've already done. Here is the code itself:

    Please Login or Register  to view this content.
    The first line in the commercial invoice works, but I can't seem to get the other lines working. Thank you in advance for anyone reading this.
    Attached Files Attached Files
    Last edited by Jonathan Bay; 06-13-2011 at 04:30 PM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: creating VB code using advanced search criteria with multiple data validation lis

    hi, Jonathan, please check attachment, I've added validation list for Product Name that depends on the Type selected, VB is used to clear Product Name after changing Type, as to the green-coloured part I'm not sure I understood where the data should come from. If you can provide a bit more clear explanation, I would look at it.
    Attached Files Attached Files
    Last edited by watersev; 06-13-2011 at 01:09 PM.

  3. #3
    Registered User
    Join Date
    05-26-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: creating VB code using advanced search criteria with multiple data validation lis

    Thank you Watersev, that's precisely what I need. I'll quickly redo the sheet and post the finished result for future reference. I'm trying to understand what you did though, the code is so short

    Thank you again!
    Attached Files Attached Files
    Last edited by Jonathan Bay; 06-13-2011 at 04:03 PM. Reason: Added finished file

  4. #4
    Registered User
    Join Date
    05-26-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: creating VB code using advanced search criteria with multiple data validation lis

    I understand how you did it now, but I made a mistake by leaving in the added column A within the StockList sheet. Unfortunately the raw data from our system doesn't include the data in column A (which I added myself by typing the individual names).
    Products are added and took away on a weekly basis, and new products can be added too, which would have to be entered in manually I guess for the first list you choose from.
    Making an automatic list to take either the first word, or the first and second word of a product wouldn't work, so I guess adding a new name to the list needs to be done manually.
    The other option I could take is having the first list choice as a hidden cell on a protected sheet, as this document would be sent protected to a customer. The same as in the DataValSelectName.xml example, but with more lines. By doing this, I'd not have to enter any data manually, I'd just need to update the product list with a single action. I'll give another example tomorrow.

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: creating VB code using advanced search criteria with multiple data validation lis

    ok, please send me a PM I will look at it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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