Userform Date Method

[ajhez]

Hi all,

Anyone have any clever/nice ways to deal with dates / calendar in a Userform?

I have a Userform which requires users to select start and end dates. I had initially opted to have this as two simple textboxes that the user would type into, but i just wondered if anyone had seen a nicer/better way to do it?

I had considered perhaps using three list boxes one each for day, month, year?

Any thoughts greatly appreciated!

Cheers,
AJHEZ

[gmayor]

I tend to use Trevor Eyre's handy Date Picker - http://bit.ly/1ossyMA which works in Excel and Word. You can call it on entry to a text box field and get it to write its value there.