ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tricky ComboBox / Filter query (https://www.excelbanter.com/excel-discussion-misc-queries/1731-tricky-combobox-filter-query.html)

[email protected]

Tricky ComboBox / Filter query
 
Here's one

On Sheet1, from A1:A2931 I have dates, every day from 01.01.02 to
31.12.2009 (A1="01/01/2002", A2="02/01/2002", etc).

On a Userform I have 2 ComboBoxes: 1 for month, one for year. Is it
possible to use these to filter Sheet1 and leave only those dates
chosen in the dropdowns (eg, December 2004 only)?

TIA

Alan



All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com