Perhaps 2 drop down boxes. One for the month and one for the year and then
you can control what the user enters. These can be placed directly in a
worksheet cell. Look up drop down in help with a worksheet displayed. (Not in
VBA Editor)

You will then need to concatenate the two selections.

Regards,

OssieMac

"Amitriumphs" wrote:

Hi all,

I need a macro with an input box accepting certain dates which matches
with the names of the folder present in C:\ drive in the format MMYYYY
and should give error message on any other character entered.

Any help would be appreciated.

Thanks,
Amit