Inserting an input request in a recorded macro

[GarryWelborn]

Hi,

I would like to record a macro which when started asks the user to filter the year from a column before going on to complete the instructions in the macro.


Is this possible and can anyone help please?

Regards

Garry

 

[Arjan77]

If you have a limited number of years you could use a userform with a combobox. Let the user pick a year and use the input to apply the filter with VBA. Then run the rest of your code.

 

[GarryWelborn]

Hi Arjan,

Thanks for your reply. The year's are limited to three academic year which are 12/13 13/14 and 14/15.

I'm afraid my knowledge on macros is very limited so I do not know how to do as you suggest?

Regards

Garry