Take a look at the DateSerial method in XL/VBA Help.

In article ,
Trent Argante wrote:

I have a UserForm that asks the user to select the year, the month, and the
day.
How do I convert this to an Excel Stored Date without having to write it to
a cell then extract the cell's value via .Formula?
Thanks,