I have a macro which when activated goes through a sequence of formatting and auto filtering procedures in a spreadsheet.
One of the filters is on a column containing dates. Currently to filter for a different range of dates I have to go into the macro and edit the date concerned. Ideally I would like a box (Input box or Message box?) to appear at some stage while the macro is running asking for the date or range of dates required. (In the same way that a parameter query operates in Access.)
Has anyone any ideas, please?
One of the filters is on a column containing dates. Currently to filter for a different range of dates I have to go into the macro and edit the date concerned. Ideally I would like a box (Input box or Message box?) to appear at some stage while the macro is running asking for the date or range of dates required. (In the same way that a parameter query operates in Access.)
Has anyone any ideas, please?