If your gonna use a textbox and you know the format expected of the user then parse the string as explained several posts above. eg. if format is mm/dd/yyyy then use array=Split(string, "/") and assign value to datetime variable with DateSerial(array(2), array(0), array(1)).