how to create search box at beginning of macro

[Macro_]

Hi all, I've created a macro that automatically updates periodic data sets. I now want to create a search box at the beginning with options to change the date/period (i.e. enter 2015 q1) for the macro to update.. would appreciate any insight. Thank you in advance

 

[ozbod]

Would need to see the macro, but you could use a Form or InputBox at the start of the macro to get the date/period and then process accordingly