Results 1 to 5 of 5

Giving the user the option to amend a portion of a fixed formula before macro is run

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    469

    Giving the user the option to amend a portion of a fixed formula before macro is run

    hi all,

    I have a bit of code which inserts 2 formula's into cells which i then use as criteria for a sort/filter.
    Currently it filters 2 date columns to include all dates between today's date and 3 months into the future.

    It now seems users might want to see dates further into the future e.g. 5 months. Is it possible to give the user the option on how many months into the future they can filter?

    edit: perhaps something like an input box?

    Range("R2").Select
        ActiveCell.FormulaR1C1 = "=""<""&EDATE(TODAY(),3)"
    Range("S2").Select
        ActiveCell.FormulaR1C1 = "="">""&TODAY()"
         
    Columns("A:O").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
            "R1:S2"), CopyToRange:=Range("T1"), Unique:=False
    Last edited by Gti182; 03-28-2014 at 06:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to amend part of formula repeatedly for remainder of sheet
    By RossChip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 07:12 AM
  2. user to amend password and view only relevant records
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-11-2012, 03:35 AM
  3. How main portion of excel to be fixed
    By Tanza in forum Excel General
    Replies: 7
    Last Post: 03-05-2011, 12:54 PM
  4. User form that can search and amend
    By nods in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-10-2010, 01:53 PM
  5. User Form to enter/amend times
    By kymbo46 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2008, 04:15 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