Excel - User Input for Custom MDX query using VBA and Pivots

I had a requirement where I wanted to do the following for a particular Power User: - Give them the ability to put in a Date as a parameter in an Excel Workbook. - Once I have this date, is to the have a custom MDX query, which will then go and get the required data for the date.