Results 1 to 2 of 2

VBA - Autofilter with Input Box

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    VBA - Autofilter with Input Box

    Hi All,

    Hope you can help, i know this can be done but i have seen some conflicting codes around and wasnt sure what is the best way.

    Basically i need to run a report based on monthly data ie accounts by x on x month

    This is part of a larger macro which is already working, but someone wanted an addition to filter out by month.

    I have attached a dummy sheet

    ideally the macro would run and then a message box would come up asking for which month you would like to evaluate (ie Jan, Feb, Mar etc) once the user enters the month it would continue with the rest of the macro

    Thanks in advance

    Euan Dummy.xlsx
    Last edited by alter_ego1981; 02-01-2013 at 05:37 PM.

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