Why not have the user enter the value directly into a cell on your worksheet. Then you can Data Validation ( -->>Data-->>Validation ) to ensure that the value entered is a date.