Results 1 to 9 of 9

Modifying sub macro from DATA to DATE

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,807

    Modifying sub macro from DATA to DATE

    Hello,

    Can someone please modify this from data to date instead. The attachment is searching data for now. I want to switch to search dates.

    Sub Macro3()
    '
    ' Macro3 Macro Search Entry Data
    '
    
    '
    Dim sFind
    sFind = InputBox("Please enter search data", "Search Box", "LB-22")
    If sFind = "" Then Exit Sub
    
        ActiveSheet.Range("$A$2:$A$17").AutoFilter Field:=1, Criteria1:="=*" & sFind & "*", _
            Operator:=xlAnd
    End Sub
    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. [SOLVED] Help to join 2 sets of data by modifying MACRO into VBA
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2021, 03:35 AM
  2. Replace a blank cell in a column by a specific text using a macro
    By sai abhilash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2016, 03:16 PM
  3. Need help with adjusting/modifying macro to fit my data
    By thlee1122 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2015, 04:43 PM
  4. Need help modifying a macro to insert rows after date change.
    By Graham Pall in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-22-2015, 06:31 AM
  5. Macro: Need help modifying macro, pasting over a row of data
    By idontexcelinexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2014, 11:41 AM
  6. Modifying sort data macro
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2010, 05:43 PM
  7. Modifying VBA to create new macro for recording data
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 12-30-2009, 08:26 PM

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