Unless you're already using a userform, creating one for this purpose could only slow down the input process - not speed it up. A date picker performs a quite different function, as it allows you to choose a date by month, week and day of week. That's rather more complex than just a list of numbers in a dropdown or something such. Besides which, you still haven't said where the numbers would come from. Presumably you wouldn't want the same number being picked multiple times, but that's precisely what a date-picker control or one like it allows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|