Inputbox - force an actual date

[nickmax1]

I want my macro to tell the user that if they put in anything other than a date in the MMM YYYY format there is a message that tells them so.

Thanks!

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Assuming that MMM and YYYY are month and year values, rather than try and validate the contents of an Input box, why not provide a couple of List Boxes from which they can choose the only allowable options. Then there is no doubt. e.g. a box with 'Jan', 'Feb', 'Mar' etc. and another with '2012;, '2013', '2014' etc.

[tigeravatar]

nickmax1,

I agree with what Richard has suggested. However, I had already put this code together by the time he posted, so I figured I'd post it instead of just deleting it:

Please Login or Register  to view this content.

[nickmax1]

that is absolutely perfect....just what i wanted.

thanks!