Print Via ComboBox That Searches Tabs and Dates

[ScotyB]

Hi all,

on the sample workbook, I have a sheet called FrontPage with a command button (currently inactive) - there are 28 tabs and the date in column B of each of those tabs is the same, formatted DD-MMM-YY...

What I would like the command button to do when clicked is this...

1. Ask the user which tab is required (either via input box or maybe a list/combo box might be better?)

2. When the user selects from that list, a second option is presented (again via list/combo box?) that gives the choice of all records in the tab or only those records by the selected month only eg:

All
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

3 Prints the selected records

Is that possible?

Thanks in advance,

AJ