+ Reply to Thread
Results 1 to 2 of 2

VBA - Data Validation as a search criteria

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Brampton
    MS-Off Ver
    2010
    Posts
    2

    VBA - Data Validation as a search criteria

    Hello Everyone,

    Basically what i would like to do is use my data validation list as a search feature.

    For example i have a data vaidation list with all the months Jan, Feb, March, etc.... set up in a list and bascially i would like to choose January and hit a button to have a bunch of other sheets display.

    I was able to use a Macro to have any drop down populate the sheets but i was not able to have them filter by month

    any help would be great

  2. #2
    Registered User
    Join Date
    08-08-2014
    Location
    Brampton
    MS-Off Ver
    2010
    Posts
    2

    Re: VBA - Data Validation as a search criteria

    this is what i have.....

    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
    Sheets("Home").Select
    Sheets("MTD").Visible = True
    Sheets("MTD").Select
    Sheets("Nov 1").Visible = True
    Sheets("Nov 1").Select
    Sheets("Nov 2").Visible = True
    Sheets("Nov 2").Select
    Sheets("Nov 3").Visible = True
    Sheets("Nov 3").Select
    Sheets("Nov 4").Visible = True
    Sheets("Home").Select
    ActiveWindow.SelectedSheets.Visible = False
    End Sub

+ 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. [SOLVED] Userform and multiple search criteria with drop down validation for 2003.
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 08:19 PM
  2. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  3. creating VB code using advanced search criteria with multiple data validation lists?
    By Jonathan Bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 09:56 AM
  4. Search Table - Advanced Filter/Data Validation?
    By EmilyB in forum Excel General
    Replies: 1
    Last Post: 01-12-2011, 01:35 AM
  5. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 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